/*
 Navicat Premium Data Transfer

 Source Server         : mysql_localhost
 Source Server Type    : MySQL
 Source Server Version : 50713
 Source Host           : localhost
 Source Database       : entranceGuard

 Target Server Type    : MySQL
 Target Server Version : 50713
 File Encoding         : utf-8

 Date: 09/16/2019 20:51:50 PM
*/

SET NAMES utf8;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
--  Table structure for `T_SYS_USER_bak`
-- ----------------------------
DROP TABLE IF EXISTS `T_SYS_USER_bak`;
CREATE TABLE `T_SYS_USER_bak` (
  `ID` bigint(19) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `CREATE_BY` bigint(19) DEFAULT NULL COMMENT '创建人',
  `CREATE_TIME` datetime DEFAULT NULL COMMENT '创建时间/注册时间',
  `MODIFY_BY` bigint(19) DEFAULT NULL COMMENT '最后更新人',
  `MODIFY_TIME` datetime DEFAULT NULL COMMENT '最后更新时间',
  `ACCOUNT` varchar(255) COLLATE utf8_bin DEFAULT NULL COMMENT '帐号',
  `AVATAR` varchar(255) COLLATE utf8_bin DEFAULT NULL COMMENT '头像',
  `BIRTHDAY` datetime DEFAULT NULL COMMENT '出生日期',
  `DEPTID` bigint(19) DEFAULT NULL COMMENT '部门编号',
  `EMAIL` varchar(255) COLLATE utf8_bin DEFAULT NULL COMMENT '邮箱',
  `NAME` varchar(255) COLLATE utf8_bin DEFAULT NULL COMMENT '姓名',
  `PASSWORD` varchar(255) COLLATE utf8_bin DEFAULT NULL COMMENT '密码',
  `PHONE` varchar(255) COLLATE utf8_bin DEFAULT NULL COMMENT '手机',
  `ROLEID` varchar(255) COLLATE utf8_bin DEFAULT NULL COMMENT '角色id',
  `SALT` varchar(255) COLLATE utf8_bin DEFAULT NULL COMMENT '盐值',
  `SEX` int(10) DEFAULT NULL COMMENT '性别',
  `STATUS` int(10) DEFAULT NULL COMMENT '状态',
  `VERSION` int(10) DEFAULT NULL COMMENT '版本',
  `credentials_type` varchar(32) COLLATE utf8_bin DEFAULT NULL COMMENT '证件类型',
  `credentials_no` varchar(32) COLLATE utf8_bin DEFAULT NULL COMMENT '证件号码',
  `position` varchar(32) COLLATE utf8_bin DEFAULT NULL COMMENT '职位',
  `Entry_Date` datetime DEFAULT NULL COMMENT '入职日期',
  PRIMARY KEY (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='系统管理员';

-- ----------------------------
--  Table structure for `pdman_db_version`
-- ----------------------------
DROP TABLE IF EXISTS `pdman_db_version`;
CREATE TABLE `pdman_db_version` (
  `DB_VERSION` varchar(256) COLLATE utf8_bin DEFAULT NULL,
  `VERSION_DESC` varchar(1024) COLLATE utf8_bin DEFAULT NULL,
  `CREATED_TIME` varchar(32) COLLATE utf8_bin DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin ROW_FORMAT=DYNAMIC;

-- ----------------------------
--  Table structure for `t_card_info`
-- ----------------------------
DROP TABLE IF EXISTS `t_card_info`;
CREATE TABLE `t_card_info` (
  `ID` bigint(19) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `CREATE_BY` bigint(19) DEFAULT NULL COMMENT '创建人',
  `CREATE_TIME` datetime DEFAULT NULL COMMENT '创建时间/注册时间',
  `MODIFY_BY` bigint(19) DEFAULT NULL COMMENT '最后更新人',
  `MODIFY_TIME` datetime DEFAULT NULL COMMENT '最后更新时间',
  `VERSION` int(10) DEFAULT NULL,
  `CARD_NO` varchar(32) COLLATE utf8_bin DEFAULT NULL COMMENT '卡号',
  PRIMARY KEY (`ID`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin ROW_FORMAT=DYNAMIC COMMENT='卡信息';

-- ----------------------------
--  Table structure for `t_door_info`
-- ----------------------------
DROP TABLE IF EXISTS `t_door_info`;
CREATE TABLE `t_door_info` (
  `ID` bigint(19) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `CREATE_BY` bigint(19) DEFAULT NULL COMMENT '创建人',
  `CREATE_TIME` datetime DEFAULT NULL COMMENT '创建时间/注册时间',
  `MODIFY_BY` bigint(19) DEFAULT NULL COMMENT '最后更新人',
  `MODIFY_TIME` datetime DEFAULT NULL COMMENT '最后更新时间',
  `VERSION` int(10) DEFAULT NULL,
  `door_name` varchar(64) COLLATE utf8_bin DEFAULT NULL COMMENT '门名称',
  `area_id` bigint(19) DEFAULT NULL COMMENT '区域id',
  `equipment_id` bigint(19) DEFAULT NULL COMMENT '门所属设备',
  `door_type` varchar(32) COLLATE utf8_bin DEFAULT NULL COMMENT '门磁类型',
  `verification_mode` varchar(32) COLLATE utf8_bin DEFAULT NULL COMMENT '验证方式',
  `door_no` int(4) DEFAULT NULL COMMENT '设备编号',
  PRIMARY KEY (`ID`) USING BTREE,
  KEY `FKjut6bk4mijj8aix7loaf99sx2` (`equipment_id`) USING BTREE,
  CONSTRAINT `FKjut6bk4mijj8aix7loaf99sx2` FOREIGN KEY (`equipment_id`) REFERENCES `t_equipment_info` (`ID`)
) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=utf8 COLLATE=utf8_bin ROW_FORMAT=DYNAMIC COMMENT='门信息';

-- ----------------------------
--  Records of `t_door_info`
-- ----------------------------
BEGIN;
INSERT INTO `t_door_info` VALUES ('2', null, null, null, null, null, '7-1', '2', '7', '', '', null), ('3', null, null, null, null, null, '7-2', '2', '7', '', '', null), ('4', null, null, null, null, null, '8-1', '1', '8', null, null, null), ('5', null, null, null, null, null, '8-2', '1', '8', '', '', null), ('6', null, null, null, null, null, '9-1', '2', '9', null, null, null), ('7', null, null, null, null, null, '9-2', '2', '9', null, null, null), ('8', null, null, null, null, null, '10-1', '2', '10', null, null, null), ('9', null, null, null, null, null, '10-2', '2', '10', null, null, null), ('10', null, null, null, null, null, '10-3', '2', '10', null, null, null), ('11', null, null, null, null, null, '10-4', '2', '10', '', '', null), ('12', null, null, null, null, null, '11-1', '1', '11', null, null, null), ('13', null, null, null, null, null, '11-2', '1', '11', null, null, null), ('14', null, null, null, null, null, '11-3', '1', '11', null, null, null), ('15', null, null, null, null, null, '11-4', '1', '11', '', '', null);
COMMIT;

-- ----------------------------
--  Table structure for `t_entrance_gard_user`
-- ----------------------------
DROP TABLE IF EXISTS `t_entrance_gard_user`;
CREATE TABLE `t_entrance_gard_user` (
  `ID` bigint(19) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `CREATE_BY` bigint(19) DEFAULT NULL COMMENT '创建人',
  `CREATE_TIME` datetime DEFAULT NULL COMMENT '创建时间/注册时间',
  `MODIFY_BY` bigint(19) DEFAULT NULL COMMENT '最后更新人',
  `MODIFY_TIME` datetime DEFAULT NULL COMMENT '最后更新时间',
  `VERSION` int(10) DEFAULT NULL,
  `RULE_ID` bigint(19) DEFAULT NULL COMMENT '权限id',
  `user_id` bigint(19) DEFAULT NULL COMMENT '人员id',
  `staus` varchar(12) COLLATE utf8_bin DEFAULT NULL COMMENT '状态',
  PRIMARY KEY (`ID`) USING BTREE,
  KEY `FK5tyxi5dj0ki9gsai2iar3vac3` (`user_id`) USING BTREE,
  KEY `FKncbrbxb512pbhkqwjdi1mdpo8` (`RULE_ID`) USING BTREE,
  CONSTRAINT `FK5tyxi5dj0ki9gsai2iar3vac3` FOREIGN KEY (`user_id`) REFERENCES `t_sys_user` (`ID`),
  CONSTRAINT `FKncbrbxb512pbhkqwjdi1mdpo8` FOREIGN KEY (`RULE_ID`) REFERENCES `t_entrance_guard_rule` (`ID`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8 COLLATE=utf8_bin ROW_FORMAT=DYNAMIC COMMENT='门禁权限与人员关系表';

-- ----------------------------
--  Records of `t_entrance_gard_user`
-- ----------------------------
BEGIN;
INSERT INTO `t_entrance_gard_user` VALUES ('3', null, null, null, null, null, '7', '2', '0'), ('4', null, null, null, null, null, '7', '1', '0'), ('5', null, null, null, null, null, '7', '-1', '0');
COMMIT;

-- ----------------------------
--  Table structure for `t_entrance_guard_door`
-- ----------------------------
DROP TABLE IF EXISTS `t_entrance_guard_door`;
CREATE TABLE `t_entrance_guard_door` (
  `ID` bigint(19) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `CREATE_BY` bigint(19) DEFAULT NULL COMMENT '创建人',
  `CREATE_TIME` datetime DEFAULT NULL COMMENT '创建时间/注册时间',
  `MODIFY_BY` bigint(19) DEFAULT NULL COMMENT '最后更新人',
  `MODIFY_TIME` datetime DEFAULT NULL COMMENT '最后更新时间',
  `VERSION` int(10) DEFAULT NULL,
  `DOOR_ID` bigint(19) DEFAULT NULL COMMENT '门id',
  `RULE_ID` bigint(19) DEFAULT NULL COMMENT '权限id',
  `equipment_id` bigint(19) DEFAULT NULL COMMENT '设备id',
  PRIMARY KEY (`ID`) USING BTREE,
  KEY `FK3dlv3i13m1hu77alk1qo7gxps` (`DOOR_ID`) USING BTREE,
  KEY `FKptplxtmajlor31yr02p2ybq76` (`RULE_ID`) USING BTREE,
  CONSTRAINT `FK3dlv3i13m1hu77alk1qo7gxps` FOREIGN KEY (`DOOR_ID`) REFERENCES `t_door_info` (`ID`),
  CONSTRAINT `FKptplxtmajlor31yr02p2ybq76` FOREIGN KEY (`RULE_ID`) REFERENCES `t_entrance_guard_rule` (`ID`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COLLATE=utf8_bin ROW_FORMAT=DYNAMIC COMMENT='门与门禁权限对应表';

-- ----------------------------
--  Records of `t_entrance_guard_door`
-- ----------------------------
BEGIN;
INSERT INTO `t_entrance_guard_door` VALUES ('1', null, null, null, null, null, '15', '1', '11'), ('2', null, null, null, null, null, '15', '3', '11');
COMMIT;

-- ----------------------------
--  Table structure for `t_entrance_guard_rule`
-- ----------------------------
DROP TABLE IF EXISTS `t_entrance_guard_rule`;
CREATE TABLE `t_entrance_guard_rule` (
  `ID` bigint(19) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `CREATE_BY` bigint(19) DEFAULT NULL COMMENT '创建人',
  `CREATE_TIME` datetime DEFAULT NULL COMMENT '创建时间/注册时间',
  `MODIFY_BY` bigint(19) DEFAULT NULL COMMENT '最后更新人',
  `MODIFY_TIME` datetime DEFAULT NULL COMMENT '最后更新时间',
  `VERSION` int(10) DEFAULT NULL,
  `rule_name` varchar(64) COLLATE utf8_bin DEFAULT NULL COMMENT '权限名称',
  `remark` varchar(255) COLLATE utf8_bin DEFAULT NULL COMMENT '备注',
  `time_id` bigint(19) DEFAULT NULL COMMENT '时段id',
  PRIMARY KEY (`ID`) USING BTREE,
  KEY `FKtqtkdqr6884e60x6nkq4y2p5p` (`time_id`) USING BTREE,
  CONSTRAINT `FKtqtkdqr6884e60x6nkq4y2p5p` FOREIGN KEY (`time_id`) REFERENCES `t_time_info` (`ID`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8 COLLATE=utf8_bin ROW_FORMAT=DYNAMIC COMMENT='门禁权限';

-- ----------------------------
--  Records of `t_entrance_guard_rule`
-- ----------------------------
BEGIN;
INSERT INTO `t_entrance_guard_rule` VALUES ('1', null, null, null, null, null, '权限1', null, '1'), ('3', null, null, null, null, null, '权限2', null, '2'), ('4', null, null, null, null, null, '权限3', null, '3'), ('5', null, null, null, null, null, '权限4', null, '3'), ('6', null, null, null, null, null, '权限5', null, '2'), ('7', null, null, null, null, null, '权限6', null, '1');
COMMIT;

-- ----------------------------
--  Table structure for `t_equipment_info`
-- ----------------------------
DROP TABLE IF EXISTS `t_equipment_info`;
CREATE TABLE `t_equipment_info` (
  `ID` bigint(19) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `CREATE_BY` bigint(19) DEFAULT NULL COMMENT '创建人',
  `CREATE_TIME` datetime DEFAULT NULL COMMENT '创建时间/注册时间',
  `MODIFY_BY` bigint(19) DEFAULT NULL COMMENT '最后更新人',
  `MODIFY_TIME` datetime DEFAULT NULL COMMENT '最后更新时间',
  `VERSION` int(10) DEFAULT NULL,
  `EQUIPMENT_NAME` varchar(255) COLLATE utf8_bin DEFAULT NULL COMMENT '设备名称',
  `communication_mode` varchar(32) COLLATE utf8_bin DEFAULT NULL COMMENT '通信方式',
  `IP_ADDRESS` varchar(32) COLLATE utf8_bin DEFAULT NULL COMMENT 'IP地址',
  `communication_post` varchar(32) COLLATE utf8_bin DEFAULT NULL COMMENT '通信端口',
  `communication_password` varchar(32) COLLATE utf8_bin DEFAULT NULL COMMENT '通信密码',
  `icon_type` varchar(32) COLLATE utf8_bin DEFAULT NULL COMMENT '图标类型',
  `controller_type` varchar(32) COLLATE utf8_bin DEFAULT NULL COMMENT '门禁控制器类型',
  `area_Id` bigint(19) DEFAULT NULL COMMENT '区域',
  `serial_number` varchar(64) COLLATE utf8_bin DEFAULT NULL COMMENT '序列号',
  PRIMARY KEY (`ID`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8 COLLATE=utf8_bin ROW_FORMAT=DYNAMIC COMMENT='设备信息表';

-- ----------------------------
--  Records of `t_equipment_info`
-- ----------------------------
BEGIN;
INSERT INTO `t_equipment_info` VALUES ('1', null, null, null, null, null, '123', '1', '10.1.1.1', '', '', '', '1', '1', '123'), ('2', null, null, null, null, null, '设备2', '1', '10.1.1.1', '', '', '', '1', '1', '1234'), ('3', null, null, null, null, null, '设备3', '1', '10.1.1.1', '', '', '', '1', '1', '124'), ('4', null, null, null, null, null, '设备4', '1', '10.1.1.1', '', '', '', '1', '1', '1235'), ('5', null, null, null, null, null, '设备5', '1', '10.1.1.1', '', '', '', '2', '2', '124'), ('6', null, null, null, null, null, '设备6', '1', '10.1.1.1', '', '', '', '2', '2', '124323'), ('7', null, null, null, null, null, '设备7', '1', '10.1.1.1', '', '', '', '2', '2', '123'), ('8', null, null, null, null, null, '设备8', '1', '10.1.1.1', '', '', '', '2', '1', '12344'), ('9', null, null, null, null, null, '设备9', '1', '10.1.1.1', '', '', '', '2', '2', '14324'), ('10', null, null, null, null, null, '设备10', '1', '10.1.1.1', '', '', '', '4', '2', '142343'), ('11', null, null, null, null, null, '设备11', '1', '10.1.1.1', '', '', '', '4', '1', '432');
COMMIT;

-- ----------------------------
--  Table structure for `t_event_record`
-- ----------------------------
DROP TABLE IF EXISTS `t_event_record`;
CREATE TABLE `t_event_record` (
  `ID` bigint(19) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `CREATE_BY` bigint(19) DEFAULT NULL COMMENT '创建人',
  `CREATE_TIME` datetime DEFAULT NULL COMMENT '创建时间/注册时间',
  `MODIFY_BY` bigint(19) DEFAULT NULL COMMENT '最后更新人',
  `MODIFY_TIME` datetime DEFAULT NULL COMMENT '最后更新时间',
  `VERSION` int(10) DEFAULT NULL,
  `CARD_NO` bigint(19) DEFAULT NULL COMMENT '卡号',
  `PIN` bigint(19) DEFAULT NULL COMMENT '人员主键',
  `VERIFIED` varchar(255) COLLATE utf8_bin DEFAULT NULL COMMENT '验证方式：3 代表“仅密码”验证；4 代表“仅卡”验证；11 代表“卡加密码”验证；200 代表“其他”',
  `DOOR_ID` int(11) DEFAULT NULL COMMENT '门ID',
  `EVENT_TYPE` varchar(255) COLLATE utf8_bin DEFAULT NULL COMMENT '事件选项EventType',
  `INOUT_STATE` varchar(255) COLLATE utf8_bin DEFAULT NULL COMMENT '进出状态',
  `TIME_SECOND` datetime DEFAULT NULL COMMENT '刷卡时间',
  `INDEX` int(10) DEFAULT NULL,
  `SITE_CODE` int(10) DEFAULT NULL,
  `equipment_id` bigint(19) DEFAULT NULL COMMENT '门所属设备',
  `equipment_name` varchar(255) COLLATE utf8_bin DEFAULT NULL COMMENT '设备名称',
  `area_name` varchar(255) COLLATE utf8_bin DEFAULT NULL COMMENT '区域名称',
  `user_id` bigint(19) DEFAULT NULL COMMENT '用户编号',
  `user_name` varchar(255) COLLATE utf8_bin DEFAULT NULL COMMENT '姓名',
  `dept_name` varchar(255) COLLATE utf8_bin DEFAULT NULL COMMENT '部门名称',
  PRIMARY KEY (`ID`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin ROW_FORMAT=DYNAMIC COMMENT='事件记录表';

-- ----------------------------
--  Table structure for `t_event_type`
-- ----------------------------
DROP TABLE IF EXISTS `t_event_type`;
CREATE TABLE `t_event_type` (
  `ID` bigint(19) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `CREATE_BY` bigint(19) DEFAULT NULL COMMENT '创建人',
  `CREATE_TIME` datetime DEFAULT NULL COMMENT '创建时间/注册时间',
  `MODIFY_BY` bigint(19) DEFAULT NULL COMMENT '最后更新人',
  `MODIFY_TIME` datetime DEFAULT NULL COMMENT '最后更新时间',
  `VERSION` int(10) DEFAULT NULL,
  `Event_code` varchar(10) DEFAULT NULL COMMENT '事件代码',
  `event_name` varchar(255) DEFAULT NULL COMMENT '事件名称',
  `event_type` varchar(2) DEFAULT NULL COMMENT '事件类型  0:正常1:异常',
  `memo` varchar(255) DEFAULT NULL COMMENT '事件说明',
  PRIMARY KEY (`ID`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=141 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

-- ----------------------------
--  Records of `t_event_type`
-- ----------------------------
BEGIN;
INSERT INTO `t_event_type` VALUES ('1', null, null, null, null, null, '0', '正常刷卡开门', '0', '指具有开门权限的人员刷卡且验证通过后所触发的正常事件'), ('2', null, null, null, null, null, '1', '常开时间段内刷卡', '0', '指具有开门权限的人员在常开时间段内（含对单个门设置的门常开时段或者首卡常开设置的开门时段），门已处于打开状态时刷有效卡所触发的正常事件'), ('3', null, null, null, null, null, '0', '正常刷卡开门', '0', '指具有开门权限的人员刷卡且验证通过后所触发的正常事件'), ('4', null, null, null, null, null, '2', '首卡开门(刷卡)', '0', '指具有首卡开门权限的人员在设定的首卡常开时间段内，门尚未打开时刷卡且验证通过后所触发的正常事件'), ('5', null, null, null, null, null, '1', '常开时间段内刷卡', '0', '指具有开门权限的人员在常开时间段内（含对单个门设置的门常开时段或者首卡常开设置的开门时段），门已处于打开状态时刷有效卡所触发的正常事件'), ('6', null, null, null, null, null, '3', '多卡开门(刷卡)', '0', '指多卡组合开门时，最后一张卡验证通过时所触发的正常事件'), ('7', null, null, null, null, null, '2', '首卡开门(刷卡)', '0', '指具有首卡开门权限的人员在设定的首卡常开时间段内，门尚未打开时刷卡且验证通过后所触发的正常事件'), ('8', null, null, null, null, null, '4', '紧急状态密码开门', '0', '指使用在当前门上设置的紧急状态密码（也称为超级密码）开门且验证通过后所触发的正常事件'), ('9', null, null, null, null, null, '3', '多卡开门(刷卡)', '0', '指多卡组合开门时，最后一张卡验证通过时所触发的正常事件'), ('10', null, null, null, null, null, '5', '常开时间段开门', '0', '指对当前门设定了门常开时间段后，到达设定的开始时间时，门自动打开所触发的事件'), ('11', null, null, null, null, null, '4', '紧急状态密码开门', '0', '指使用在当前门上设置的紧急状态密码（也称为超级密码）开门且验证通过后所触发的正常事件'), ('12', null, null, null, null, null, '6', '触发联动事件', '0', '当设定的联动生效时，触发该正常事件'), ('13', null, null, null, null, null, '5', '常开时间段开门', '0', '指对当前门设定了门常开时间段后，到达设定的开始时间时，门自动打开所触发的事件'), ('14', null, null, null, null, null, '7', '取消报警', '0', '当用户对存在报警的门进行了取消报警操作，且取消报警成功时，触发该正常事件'), ('15', null, null, null, null, null, '6', '触发联动事件', '0', '当设定的联动生效时，触发该正常事件'), ('16', null, null, null, null, null, '8', '远程开门', '0', '当用户对某个门进行远程开门操作且开门成功时，触发该正常事件'), ('17', null, null, null, null, null, '9', '远程关门', '0', '当用户对某个门进行远程关门操作且关门成功时，触发该正常事件'), ('18', null, null, null, null, null, '7', '取消报警', '0', '当用户对存在报警的门进行了取消报警操作，且取消报警成功时，触发该正常事件'), ('19', null, null, null, null, null, '10', '禁用当天常开时间段', '0', '当门处于常开状态时，在读头上刷五下有效卡（必须为同一个用户）或者使用ControlDevice来禁用当天常开时间段时，触发该正常事件。'), ('20', null, null, null, null, null, '8', '远程开门', '0', '当用户对某个门进行远程开门操作且开门成功时，触发该正常事件'), ('21', null, null, null, null, null, '11', '启用当天常开时间段', '0', '当门的当天常开时间段已被禁用时，在读头上刷五下有效卡（必须为同一个用户）或者使用ControlDevice来启用该门当天常开时间段时，触发该正常事件。'), ('22', null, null, null, null, null, '9', '远程关门', '0', '当用户对某个门进行远程关门操作且关门成功时，触发该正常事件'), ('23', null, null, null, null, null, '12', '开启辅助输出', '0', '用户在联动设置中设定的联动动作，如果输出点地址选择了辅助输出点，动作类型选择了打开，则当该联动设置生效时，将会触发该正常事件。'), ('24', null, null, null, null, null, '10', '禁用当天常开时间段', '0', '当门处于常开状态时，在读头上刷五下有效卡（必须为同一个用户）或者使用ControlDevice来禁用当天常开时间段时，触发该正常事件。'), ('25', null, null, null, null, null, '13', '关闭辅助输出', '0', '用户在通过联动关闭了辅助输出或者直接调用ControlDevice关闭辅助输出时触发的事件。'), ('26', null, null, null, null, null, '11', '启用当天常开时间段', '0', '当门的当天常开时间段已被禁用时，在读头上刷五下有效卡（必须为同一个用户）或者使用ControlDevice来启用该门当天常开时间段时，触发该正常事件。'), ('27', null, null, null, null, null, '14', '正常按指纹开门', '0', '指在“仅指纹”或者“卡或指纹”的验证方式下，具有开门权限的人员按指纹且验证通过后所触发的正常事件。'), ('28', null, null, null, null, null, '12', '开启辅助输出', '0', '用户在联动设置中设定的联动动作，如果输出点地址选择了辅助输出点，动作类型选择了打开，则当该联动设置生效时，将会触发该正常事件。'), ('29', null, null, null, null, null, '15', '多卡开门(按指纹)', '0', '多卡开门（按指纹）：指多卡组合开门时，在“仅指纹”的验证方式下，最后一个指纹验证通过时所触发的正常事件。'), ('30', null, null, null, null, null, '13', '关闭辅助输出', '0', '用户在通过联动关闭了辅助输出或者直接调用ControlDevice关闭辅助输出时触发的事件。'), ('31', null, null, null, null, null, '16', '常开时间段内按指纹', '0', '指具有开门权限的人员在常开时间段内（含对单个门设置的门常开时段或者首卡开门（常开）设置的开门时段），以及通过远程开门常开的操作，门已处于打开状态时按有效指纹所触发的正常事件。'), ('32', null, null, null, null, null, '14', '正常按指纹开门', '0', '指在“仅指纹”或者“卡或指纹”的验证方式下，具有开门权限的人员按指纹且验证通过后所触发的正常事件。'), ('33', null, null, null, null, null, '17', '卡加指纹开门', '0', '指在“卡加指纹”的验证方式下，具有开门权限的人员刷卡并按指纹且验证通过后所触发的正常事件。'), ('34', null, null, null, null, null, '15', '多卡开门(按指纹)', '0', '多卡开门（按指纹）：指多卡组合开门时，在“仅指纹”的验证方式下，最后一个指纹验证通过时所触发的正常事件。'), ('35', null, null, null, null, null, '18', '首卡开门(按指纹)', '0', '指在仅指纹或者卡或指纹的验证方式下，具有首卡开门权限的人员在设定的首卡常开时间段内，门尚未打开时按指纹且验证通过后所触发的正常事件。'), ('36', null, null, null, null, null, '16', '常开时间段内按指纹', '0', '指具有开门权限的人员在常开时间段内（含对单个门设置的门常开时段或者首卡开门（常开）设置的开门时段），以及通过远程开门常开的操作，门已处于打开状态时按有效指纹所触发的正常事件。'), ('37', null, null, null, null, null, '19', '首卡开门(卡加指纹)', '0', '指在卡加指纹的验证方式下，具有首卡开门权限的人员在设定的首卡常开时间段内，门尚未打开时刷卡并按指纹且验证通过后所触发的正常事件'), ('38', null, null, null, null, null, '17', '卡加指纹开门', '0', '指在“卡加指纹”的验证方式下，具有开门权限的人员刷卡并按指纹且验证通过后所触发的正常事件。'), ('39', null, null, null, null, null, '20', '刷卡间隔太短', '1', '当两次刷卡之间的间隔小于该门设定的刷卡间隔时间时，触发该异常事件'), ('40', null, null, null, null, null, '18', '首卡开门(按指纹)', '0', '指在仅指纹或者卡或指纹的验证方式下，具有首卡开门权限的人员在设定的首卡常开时间段内，门尚未打开时按指纹且验证通过后所触发的正常事件。'), ('41', null, null, null, null, null, '21', '门非有效时间段(刷卡)', '1', '指具有当前门开门权限的卡，在设定的门有效时间段之外的时间刷卡所触发的异常事件'), ('42', null, null, null, null, null, '19', '首卡开门(卡加指纹)', '0', '指在卡加指纹的验证方式下，具有首卡开门权限的人员在设定的首卡常开时间段内，门尚未打开时刷卡并按指纹且验证通过后所触发的正常事件'), ('43', null, null, null, null, null, '22', '非法时间段', '1', '指具有当前门开门权限的卡，在门禁权限设定的时间段之外的时间刷卡所触发的异常事件'), ('44', null, null, null, null, null, '20', '刷卡间隔太短', '1', '当两次刷卡之间的间隔小于该门设定的刷卡间隔时间时，触发该异常事件'), ('45', null, null, null, null, null, '23', '非法访问', '1', '已注册的卡，尚未在当前门设置门禁权限时刷卡所触发的异常事件'), ('46', null, null, null, null, null, '21', '门非有效时间段(刷卡)', '1', '指具有当前门开门权限的卡，在设定的门有效时间段之外的时间刷卡所触发的异常事件'), ('47', null, null, null, null, null, '24', '反潜', '1', '当系统内设定的反潜规则生效时，触发该异常事件'), ('48', null, null, null, null, null, '22', '非法时间段', '1', '指具有当前门开门权限的卡，在门禁权限设定的时间段之外的时间刷卡所触发的异常事件'), ('49', null, null, null, null, null, '25', '互锁', '1', '当系统内设定的互锁规则生效时，触发该异常事件'), ('50', null, null, null, null, null, '26', '多卡验证(刷卡)', '0', '指多卡组合开门时，最后一张卡之前的刷卡验证（无论通过与否），触发该事件'), ('51', null, null, null, null, null, '23', '非法访问', '1', '已注册的卡，尚未在当前门设置门禁权限时刷卡所触发的异常事件'), ('52', null, null, null, null, null, '27', '卡未注册', '1', '指当前卡号未注册时，所触发的事件'), ('53', null, null, null, null, null, '24', '反潜', '1', '当系统内设定的反潜规则生效时，触发该异常事件'), ('54', null, null, null, null, null, '28', '门开超时', '1', '门被打开后超过延时时间后检测门磁，如果门没有关上，触发该事件'), ('55', null, null, null, null, null, '25', '互锁', '1', '当系统内设定的互锁规则生效时，触发该异常事件'), ('56', null, null, null, null, null, '29', '卡已过有效期', '1', '当已设置门禁有效时间的人员，在结束门禁日期后刷卡无法验证通过，触发该事件'), ('57', null, null, null, null, null, '26', '多卡验证(刷卡)', '0', '指多卡组合开门时，最后一张卡之前的刷卡验证（无论通过与否），触发该事件'), ('58', null, null, null, null, null, '27', '卡未注册', '1', '指当前卡号未注册时，所触发的事件'), ('59', null, null, null, null, null, '28', '门开超时', '1', '门被打开后超过延时时间后检测门磁，如果门没有关上，触发该事件'), ('60', null, null, null, null, null, '30', '密码错误', '1', '使用卡加密码验证方式或者胁迫密码、紧急密码开门时，密码验证错误触发该事件'), ('61', null, null, null, null, null, '29', '卡已过有效期', '1', '当已设置门禁有效时间的人员，在结束门禁日期后刷卡无法验证通过，触发该事件'), ('62', null, null, null, null, null, '31', '按指纹间隔太短', '1', '当两次按指纹之间的间隔小于该门设定的刷卡间隔时间时，触发该异常事件'), ('63', null, null, null, null, null, '30', '密码错误', '1', '使用卡加密码验证方式或者胁迫密码、紧急密码开门时，密码验证错误触发该事件'), ('64', null, null, null, null, null, '32', '多卡验证(按指纹)', '0', '指在仅指纹或者卡或指纹验证方式下，多卡组合开门时，最后一次验证之前的指纹验证（无论通过与否），触发该事件'), ('65', null, null, null, null, null, '33', '指纹已过有效期', '1', '当已设置门禁有效时间的人员，在结束门禁日期后按指纹无法验证通过，触发该事件。'), ('66', null, null, null, null, null, '31', '按指纹间隔太短', '1', '当两次按指纹之间的间隔小于该门设定的刷卡间隔时间时，触发该异常事件'), ('67', null, null, null, null, null, '34', '指纹未注册', '1', '指当前指纹未在系统内登记或者虽已登记但未同步到设备中，所触发的事件。'), ('68', null, null, null, null, null, '32', '多卡验证(按指纹)', '0', '指在仅指纹或者卡或指纹验证方式下，多卡组合开门时，最后一次验证之前的指纹验证（无论通过与否），触发该事件'), ('69', null, null, null, null, null, '35', '门非有效时间段(按指纹)', '1', '指具有当前门开门权限的人员，在设定的门有效时间段之外的时间按指纹所触发的异常事件'), ('70', null, null, null, null, null, '33', '指纹已过有效期', '1', '当已设置门禁有效时间的人员，在结束门禁日期后按指纹无法验证通过，触发该事件。'), ('71', null, null, null, null, null, '36', '门非有效时间段(按出门按钮)', '1', '在设定的门有效时间段外按出门按钮，无法开门时产生此事件'), ('72', null, null, null, null, null, '34', '指纹未注册', '1', '指当前指纹未在系统内登记或者虽已登记但未同步到设备中，所触发的事件。'), ('73', null, null, null, null, null, '37', '常开时间段无法关门', '1', '指当前门正处在常开状态，无法通过ControlDevice关门时所触发的异常事件'), ('74', null, null, null, null, null, '38', '卡已挂失', '1', '当卡号被挂失处理时，刷对应的卡触发的事件'), ('75', null, null, null, null, null, '35', '门非有效时间段(按指纹)', '1', '指具有当前门开门权限的人员，在设定的门有效时间段之外的时间按指纹所触发的异常事件'), ('76', null, null, null, null, null, '39', '黑名单', '1', '当用户号被划为黑名单时，该用户进行任何比对都会产生此事件。'), ('77', null, null, null, null, null, '36', '门非有效时间段(按出门按钮)', '1', '在设定的门有效时间段外按出门按钮，无法开门时产生此事件'), ('78', null, null, null, null, null, '40', '多指纹验证失败', '1', '组合验证时，多用户进行指纹比对，其中有一用户指纹验证失败时产生该事件'), ('79', null, null, null, null, null, '37', '常开时间段无法关门', '1', '指当前门正处在常开状态，无法通过ControlDevice关门时所触发的异常事件'), ('80', null, null, null, null, null, '41', '验证方式错误', '1', '当用户所使用的验证方式与设定不一致时产生该事件'), ('81', null, null, null, null, null, '38', '卡已挂失', '1', '当卡号被挂失处理时，刷对应的卡触发的事件'), ('82', null, null, null, null, null, '42', '韦根格式错误', '1', '所刷的卡的位数与配置不一致时，刷卡触发事件'), ('83', null, null, null, null, null, '39', '黑名单', '1', '当用户号被划为黑名单时，该用户进行任何比对都会产生此事件。'), ('84', null, null, null, null, null, '43', '后台验证', '1', ''), ('85', null, null, null, null, null, '40', '多指纹验证失败', '1', '组合验证时，多用户进行指纹比对，其中有一用户指纹验证失败时产生该事件'), ('86', null, null, null, null, null, '44', '后台验证失败', '1', ''), ('87', null, null, null, null, null, '41', '验证方式错误', '1', '当用户所使用的验证方式与设定不一致时产生该事件'), ('88', null, null, null, null, null, '45', '后台验证超时', '1', ''), ('89', null, null, null, null, null, '42', '韦根格式错误', '1', '所刷的卡的位数与配置不一致时，刷卡触发事件'), ('90', null, null, null, null, null, '46', '后台验证事件', '1', ''), ('91', null, null, null, null, null, '43', '后台验证', '1', ''), ('92', null, null, null, null, null, '47', '发送命令失败', '1', '梯控中定义，用于主控发命令给分控时通讯失败提示的事件'), ('93', null, null, null, null, null, '44', '后台验证失败', '1', ''), ('94', null, null, null, null, null, '48', '多卡开门失败', '1', '组合验证失败时提示的事件'), ('95', null, null, null, null, null, '45', '后台验证超时', '1', ''), ('96', null, null, null, null, null, '100', '防拆报警', '1', '机器被拆除时上传的事件'), ('97', null, null, null, null, null, '46', '后台验证事件', '1', ''), ('98', null, null, null, null, null, '101', '胁迫密码开门', '1', '指使用在当前门上设置的胁迫密码开门且验证通过后所触发的报警事件'), ('99', null, null, null, null, null, '47', '发送命令失败', '1', '梯控中定义，用于主控发命令给分控时通讯失败提示的事件'), ('100', null, null, null, null, null, '102', '门被意外打开', '1', '指在正常事件（如门禁权限的人员刷卡开门、密码开门、门常开时段开门、远程开门、联动设置的开门）以外的情况下，使得门磁检测到门被打开的情况，均为门被意外打开'), ('101', null, null, null, null, null, '48', '多卡开门失败', '1', '组合验证失败时提示的事件'), ('102', null, null, null, null, null, '103', '胁迫指纹开门', '1', '指人员使用已经登记的胁迫指纹开门时所触发的报警事'), ('103', null, null, null, null, null, '100', '防拆报警', '1', '机器被拆除时上传的事件'), ('104', null, null, null, null, null, '200', '门已打开', '0', '当门磁检测到门已被正常打开时，触发该正常事件'), ('105', null, null, null, null, null, '101', '胁迫密码开门', '1', '指使用在当前门上设置的胁迫密码开门且验证通过后所触发的报警事件'), ('106', null, null, null, null, null, '201', '门已关闭', '0', '当门磁检测到门已被正常关闭时，触发该正常事件'), ('107', null, null, null, null, null, '102', '门被意外打开', '1', '指在正常事件（如门禁权限的人员刷卡开门、密码开门、门常开时段开门、远程开门、联动设置的开门）以外的情况下，使得门磁检测到门被打开的情况，均为门被意外打开'), ('108', null, null, null, null, null, '202', '出门按钮开门', '0', '当使用出门按钮开门时，触发该正常事件'), ('109', null, null, null, null, null, '103', '胁迫指纹开门', '1', '指人员使用已经登记的胁迫指纹开门时所触发的报警事'), ('110', null, null, null, null, null, '203', '多卡开门(卡加指纹)', '0', '指多卡组合开门时，在“卡加指纹”的验证方式下，最后一次卡加指纹验证通过时所触发的正常事件。'), ('111', null, null, null, null, null, '200', '门已打开', '0', '当门磁检测到门已被正常打开时，触发该正常事件'), ('112', null, null, null, null, null, '204', '常开时间段结束', '0', '设置的常开时间到，门将自动关闭，门常开包含了设置门的门常开时间段以及设置首卡开门时选择的时间段'), ('113', null, null, null, null, null, '201', '门已关闭', '0', '当门磁检测到门已被正常关闭时，触发该正常事件'), ('114', null, null, null, null, null, '205', '远程开门常开', '0', '指使用远程开门时选择常开让门处于常开状态时，触发的正常事件'), ('115', null, null, null, null, null, '202', '出门按钮开门', '0', '当使用出门按钮开门时，触发该正常事件'), ('116', null, null, null, null, null, '206', '设备启动', '0', '设备启动时触发该正常事件'), ('117', null, null, null, null, null, '203', '多卡开门(卡加指纹)', '0', '指多卡组合开门时，在“卡加指纹”的验证方式下，最后一次卡加指纹验证通过时所触发的正常事件。'), ('118', null, null, null, null, null, '204', '常开时间段结束', '0', '设置的常开时间到，门将自动关闭，门常开包含了设置门的门常开时间段以及设置首卡开门时选择的时间段'), ('119', null, null, null, null, null, '207', '密码开门', '0', '用户使用密码产生开门事件'), ('120', null, null, null, null, null, '208', '超级用户开门', '0', '用户为超级用户比对时产生的事件'), ('121', null, null, null, null, null, '205', '远程开门常开', '0', '指使用远程开门时选择常开让门处于常开状态时，触发的正常事件'), ('122', null, null, null, null, null, '209', '门被锁定', '0', '主要针对出门开关按键功能，将门配置为锁定状态时，使用出门开关按键不能开门，并触发此事件。'), ('123', null, null, null, null, null, '206', '设备启动', '0', '设备启动时触发该正常事件'), ('124', null, null, null, null, null, '210', '消防开启', '0', '消防功能，使用所有门全部常开'), ('125', null, null, null, null, null, '207', '密码开门', '0', '用户使用密码产生开门事件'), ('126', null, null, null, null, null, '211', '超级用户关门', '0', '梯控中使用事件，超级用户启动常开后，再刷卡一次即可关闭常开状态。'), ('127', null, null, null, null, null, '208', '超级用户开门', '0', '用户为超级用户比对时产生的事件'), ('128', null, null, null, null, null, '220', '辅助输入点断开', '0', '当辅助输入点断开时，触发该正常事件'), ('129', null, null, null, null, null, '209', '门被锁定', '0', '主要针对出门开关按键功能，将门配置为锁定状态时，使用出门开关按键不能开门，并触发此事件。'), ('130', null, null, null, null, null, '221', '辅助输入点短路', '0', '当辅助输入点短路时，触发该正常事件'), ('131', null, null, null, null, null, '210', '消防开启', '0', '消防功能，使用所有门全部常开'), ('132', null, null, null, null, null, '222', '后台验证成功', '0', ''), ('133', null, null, null, null, null, '211', '超级用户关门', '0', '梯控中使用事件，超级用户启动常开后，再刷卡一次即可关闭常开状态。'), ('134', null, null, null, null, null, '223', '后台验证网络不稳开门', '1', ''), ('135', null, null, null, null, null, '220', '辅助输入点断开', '0', '当辅助输入点断开时，触发该正常事件'), ('136', null, null, null, null, null, '224', '后台重新启用反潜', '1', ''), ('137', null, null, null, null, null, '221', '辅助输入点短路', '0', '当辅助输入点短路时，触发该正常事件'), ('138', null, null, null, null, null, '222', '后台验证成功', '0', ''), ('139', null, null, null, null, null, '223', '后台验证网络不稳开门', '1', ''), ('140', null, null, null, null, null, '224', '后台重新启用反潜', '1', '');
COMMIT;

-- ----------------------------
--  Table structure for `t_message`
-- ----------------------------
DROP TABLE IF EXISTS `t_message`;
CREATE TABLE `t_message` (
  `ID` bigint(19) NOT NULL AUTO_INCREMENT,
  `CREATE_BY` bigint(19) DEFAULT NULL COMMENT '创建人',
  `CREATE_TIME` datetime DEFAULT NULL COMMENT '创建时间/注册时间',
  `MODIFY_BY` bigint(19) DEFAULT NULL COMMENT '最后更新人',
  `MODIFY_TIME` datetime DEFAULT NULL COMMENT '最后更新时间',
  `CONTENT` text COLLATE utf8_bin COMMENT '消息内容',
  `RECEIVER` varchar(64) COLLATE utf8_bin DEFAULT NULL COMMENT '接收者',
  `STATE` varchar(32) COLLATE utf8_bin DEFAULT NULL COMMENT '消息类型,0:初始,1:成功,2:失败',
  `TPL_CODE` varchar(32) COLLATE utf8_bin DEFAULT NULL COMMENT '模板编码',
  `TYPE` varchar(32) COLLATE utf8_bin DEFAULT NULL COMMENT '消息类型,0:短信,1:邮件',
  PRIMARY KEY (`ID`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_bin ROW_FORMAT=DYNAMIC COMMENT='历史消息';

-- ----------------------------
--  Records of `t_message`
-- ----------------------------
BEGIN;
INSERT INTO `t_message` VALUES ('1', null, '2019-06-10 21:20:16', null, null, 0xe38090e885bee8aeafe4ba91e38091e6a0a1e9aa8ce7a08131303332efbc8ce8afb7e4ba8e35e58886e9929fe58685e5ae8ce68890e9aa8ce8af81efbc8ce5a682e99d9ee69cace4babae6938de4bd9ce8afb7e5bfbde795a5e69cace79fade4bfa1e38082, '15021592814', '2', 'REGISTER_CODE', '0');
COMMIT;

-- ----------------------------
--  Table structure for `t_message_sender`
-- ----------------------------
DROP TABLE IF EXISTS `t_message_sender`;
CREATE TABLE `t_message_sender` (
  `ID` bigint(19) NOT NULL AUTO_INCREMENT,
  `CREATE_BY` bigint(19) DEFAULT NULL COMMENT '创建人',
  `CREATE_TIME` datetime DEFAULT NULL COMMENT '创建时间/注册时间',
  `MODIFY_BY` bigint(19) DEFAULT NULL COMMENT '最后更新人',
  `MODIFY_TIME` datetime DEFAULT NULL COMMENT '最后更新时间',
  `CLASS_NAME` varchar(64) COLLATE utf8_bin DEFAULT NULL COMMENT '发送类',
  `NAME` varchar(64) COLLATE utf8_bin DEFAULT NULL COMMENT '名称',
  `TPL_CODE` varchar(64) COLLATE utf8_bin DEFAULT NULL COMMENT '短信运营商模板编号',
  PRIMARY KEY (`ID`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COLLATE=utf8_bin ROW_FORMAT=DYNAMIC COMMENT='消息发送者';

-- ----------------------------
--  Records of `t_message_sender`
-- ----------------------------
BEGIN;
INSERT INTO `t_message_sender` VALUES ('1', null, null, null, null, 'tencentSmsSender', ' 腾讯短信服务', null), ('2', null, null, null, null, 'defaultEmailSender', '默认邮件发送器', null);
COMMIT;

-- ----------------------------
--  Table structure for `t_message_template`
-- ----------------------------
DROP TABLE IF EXISTS `t_message_template`;
CREATE TABLE `t_message_template` (
  `ID` bigint(19) NOT NULL AUTO_INCREMENT,
  `CREATE_BY` bigint(19) DEFAULT NULL COMMENT '创建人',
  `CREATE_TIME` datetime DEFAULT NULL COMMENT '创建时间/注册时间',
  `MODIFY_BY` bigint(19) DEFAULT NULL COMMENT '最后更新人',
  `MODIFY_TIME` datetime DEFAULT NULL COMMENT '最后更新时间',
  `CODE` varchar(32) COLLATE utf8_bin DEFAULT NULL COMMENT '编号',
  `COND` varchar(32) COLLATE utf8_bin DEFAULT NULL COMMENT '发送条件',
  `CONTENT` text COLLATE utf8_bin COMMENT '内容',
  `ID_MESSAGE_SENDER` bigint(19) DEFAULT NULL COMMENT '发送者id',
  `TITLE` varchar(64) COLLATE utf8_bin DEFAULT NULL COMMENT '标题',
  `TYPE` varchar(32) COLLATE utf8_bin DEFAULT NULL COMMENT '消息类型,0:短信,1:邮件',
  PRIMARY KEY (`ID`) USING BTREE,
  KEY `FK942sadqk5x9kbrwil0psyek3n` (`ID_MESSAGE_SENDER`) USING BTREE,
  CONSTRAINT `FK942sadqk5x9kbrwil0psyek3n` FOREIGN KEY (`ID_MESSAGE_SENDER`) REFERENCES `t_message_sender` (`ID`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COLLATE=utf8_bin ROW_FORMAT=DYNAMIC COMMENT='消息模板';

-- ----------------------------
--  Records of `t_message_template`
-- ----------------------------
BEGIN;
INSERT INTO `t_message_template` VALUES ('1', null, null, null, null, 'REGISTER_CODE', '注册页面，点击获取验证码', 0xe38090e885bee8aeafe4ba91e38091e6a0a1e9aa8ce7a0817b317defbc8ce8afb7e4ba8e35e58886e9929fe58685e5ae8ce68890e9aa8ce8af81efbc8ce5a682e99d9ee69cace4babae6938de4bd9ce8afb7e5bfbde795a5e69cace79fade4bfa1e38082, '1', '注册验证码', '0'), ('2', null, null, null, null, 'EMAIL_TEST', '测试发送', 0xe4bda0e5a5bd3a7b317d2ce6aca2e8bf8ee4bdbfe794a87b327d, '2', '测试邮件', '1'), ('3', null, null, null, null, 'EMAIL_HTML_TEMPLATE_TEST', '测试发送模板邮件', 0xe4bda0e5a5bd3c7374726f6e673e247b757365724e616d657d3c2f7374726f6e673ee6aca2e8bf8ee4bdbfe794a83c666f6e7420636f6c6f723d22726564223e247b6170704e616d657d3c2f666f6e743e2ce8bf99e698af68746d6ce6a8a1e69dbfe982aee4bbb6, '2', '测试发送模板邮件', '1');
COMMIT;

-- ----------------------------
--  Table structure for `t_sys_cfg`
-- ----------------------------
DROP TABLE IF EXISTS `t_sys_cfg`;
CREATE TABLE `t_sys_cfg` (
  `ID` bigint(19) NOT NULL AUTO_INCREMENT,
  `CREATE_BY` bigint(19) DEFAULT NULL COMMENT '创建人',
  `CREATE_TIME` datetime DEFAULT NULL COMMENT '创建时间/注册时间',
  `MODIFY_BY` bigint(19) DEFAULT NULL COMMENT '最后更新人',
  `MODIFY_TIME` datetime DEFAULT NULL COMMENT '最后更新时间',
  `CFG_DESC` text COLLATE utf8_bin COMMENT '备注',
  `CFG_NAME` varchar(256) COLLATE utf8_bin DEFAULT NULL COMMENT '参数名',
  `CFG_VALUE` varchar(512) COLLATE utf8_bin DEFAULT NULL COMMENT '参数值',
  PRIMARY KEY (`ID`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8 COLLATE=utf8_bin ROW_FORMAT=DYNAMIC COMMENT='系统参数';

-- ----------------------------
--  Records of `t_sys_cfg`
-- ----------------------------
BEGIN;
INSERT INTO `t_sys_cfg` VALUES ('1', null, null, '1', '2019-04-15 21:36:07', 0xe5ba94e794a8e5908de7a7b075706461746520627920323031392d30332d32372031313a34373a3034, 'system.app.name', 'guns-lite'), ('2', null, null, '1', '2019-04-15 21:36:17', 0xe7b3bbe7bb9fe9bb98e8aea4e4b88ae4bca0e69687e4bbb6e8b7afe5be84, 'system.file.upload.path', '/data/guns-lite/runtime/upload'), ('3', null, null, '1', '2019-04-15 21:36:17', 0xe885bee8aeaf736d73e68ea5e58fa36170706964, 'api.tencent.sms.appid', '1400219425'), ('4', null, null, '1', '2019-04-15 21:36:17', 0xe885bee8aeaf736d73e68ea5e58fa36170706b6579, 'api.tencent.sms.appkey', '5f71ed5325f3b292946530a1773e997a'), ('5', null, null, '1', '2019-04-15 21:36:17', 0xe885bee8aeaf736d73e68ea5e58fa3e7adbee5908de58f82e695b0, 'api.tencent.sms.sign', '需要去申请咯');
COMMIT;

-- ----------------------------
--  Table structure for `t_sys_dept`
-- ----------------------------
DROP TABLE IF EXISTS `t_sys_dept`;
CREATE TABLE `t_sys_dept` (
  `ID` bigint(19) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `CREATE_BY` bigint(19) DEFAULT NULL COMMENT '创建人',
  `CREATE_TIME` datetime DEFAULT NULL COMMENT '创建时间/注册时间',
  `MODIFY_BY` bigint(19) DEFAULT NULL COMMENT '最后更新人',
  `MODIFY_TIME` datetime DEFAULT NULL COMMENT '最后更新时间',
  `FULLNAME` varchar(255) COLLATE utf8_bin DEFAULT NULL COMMENT '全称',
  `NUM` int(10) DEFAULT NULL COMMENT '排序',
  `PID` bigint(19) DEFAULT NULL COMMENT '父id',
  `PIDS` varchar(255) COLLATE utf8_bin DEFAULT NULL COMMENT '父ids',
  `SIMPLENAME` varchar(255) COLLATE utf8_bin DEFAULT NULL COMMENT '简称',
  `TIPS` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `VERSION` int(10) DEFAULT NULL,
  PRIMARY KEY (`ID`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8 COLLATE=utf8_bin ROW_FORMAT=DYNAMIC COMMENT='部门';

-- ----------------------------
--  Records of `t_sys_dept`
-- ----------------------------
BEGIN;
INSERT INTO `t_sys_dept` VALUES ('1', '1', '2019-08-15 16:31:13', '1', '2019-08-15 16:31:13', '山迪亚集团', '1', '0', '[0],', '总公司', '', null), ('2', '1', '2019-08-15 16:31:13', '1', '2019-08-15 16:31:13', '开发部', '2', '1', '[0],[1],', '开发部', null, null), ('3', '1', '2019-08-15 16:31:13', '1', '2019-08-15 16:31:13', '运营部', '3', '1', '[0],[1],', '运营部', null, null), ('4', '1', '2019-08-15 16:31:13', '1', '2019-08-15 16:31:13', '战略部', '4', '1', '[0],[1],', '战略部', null, null), ('5', '1', '2019-08-15 16:31:13', '1', '2019-08-15 16:31:13', '人事部', '5', '1', '[0],[1],', '人事部', null, null), ('6', '1', '2019-08-15 16:31:13', '1', '2019-08-15 16:31:13', '行政部', '6', '1', '[0],[1],', '行政部', null, null), ('7', '1', '2019-08-15 16:31:13', '1', '2019-08-15 16:31:13', '山迪亚上海有限责任公司', '7', '1', '[0],[1],', '上海分公司', '', null), ('8', '1', '2019-08-15 16:31:13', '1', '2019-08-15 16:31:13', '运维部', '8', '7', '[0],[1],[7],', '运维部', null, null), ('9', '1', '2019-08-15 16:31:13', '1', '2019-08-15 16:31:13', '销售部', '9', '7', '[0],[1],[7],', '销售部', null, null);
COMMIT;

-- ----------------------------
--  Table structure for `t_sys_dict`
-- ----------------------------
DROP TABLE IF EXISTS `t_sys_dict`;
CREATE TABLE `t_sys_dict` (
  `ID` bigint(19) NOT NULL AUTO_INCREMENT,
  `CREATE_BY` bigint(19) DEFAULT NULL COMMENT '创建人',
  `CREATE_TIME` datetime DEFAULT NULL COMMENT '创建时间/注册时间',
  `MODIFY_BY` bigint(19) DEFAULT NULL COMMENT '最后更新人',
  `MODIFY_TIME` datetime DEFAULT NULL COMMENT '最后更新时间',
  `NAME` varchar(32) COLLATE utf8_bin DEFAULT NULL COMMENT '字典显示值',
  `PID` bigint(19) DEFAULT NULL COMMENT '字典组id',
  `VALUE` varchar(32) COLLATE utf8_bin DEFAULT NULL COMMENT '字典值',
  PRIMARY KEY (`ID`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=89 DEFAULT CHARSET=utf8 COLLATE=utf8_bin ROW_FORMAT=DYNAMIC COMMENT='字典';

-- ----------------------------
--  Records of `t_sys_dict`
-- ----------------------------
BEGIN;
INSERT INTO `t_sys_dict` VALUES ('16', '1', '2019-01-13 14:18:21', '1', '2019-01-13 14:18:21', '状态', '0', '0'), ('17', '1', '2019-01-13 14:18:21', '1', '2019-01-13 14:18:21', '启用', '16', '1'), ('18', '1', '2019-01-13 14:18:21', '1', '2019-01-13 14:18:21', '禁用', '16', '2'), ('29', '1', '2019-07-23 21:30:09', '1', '2019-07-23 21:30:09', '性别', '0', '0'), ('30', '1', '2019-07-23 21:30:09', '1', '2019-07-23 21:30:09', '男', '29', '1'), ('31', '1', '2019-07-23 21:30:09', '1', '2019-07-23 21:30:09', '女', '29', '2'), ('35', '1', '2019-01-13 14:18:21', '1', '2019-01-13 14:18:21', '账号状态', '0', '0'), ('36', '1', '2019-01-13 14:18:21', '1', '2019-01-13 14:18:21', '启用', '35', '1'), ('37', '1', '2019-01-13 14:18:21', '1', '2019-01-13 14:18:21', '冻结', '35', '2'), ('38', '1', '2019-01-13 14:18:21', '1', '2019-01-13 14:18:21', '已删除', '35', '3'), ('53', '1', '2019-01-13 14:18:21', '1', '2019-01-13 14:18:21', '证件类型', '0', '0'), ('54', '1', '2019-01-13 14:18:21', '1', '2019-01-13 14:18:21', '身份证', '53', '1'), ('55', '1', '2019-07-23 21:30:09', '1', '2019-07-23 21:30:09', '护照', '53', '2'), ('68', '1', '2019-07-23 21:30:09', '1', '2019-07-23 21:30:09', '是否', '0', '0'), ('69', '1', '2019-07-23 21:30:09', '1', '2019-07-23 21:30:09', '是', '68', '1'), ('70', '1', '2019-01-13 14:18:21', '1', '2019-01-13 14:18:21', '否', '68', '0'), ('71', '1', '2019-07-23 21:30:09', '1', '2019-07-23 21:30:09', '消息类型', '0', '0'), ('72', '1', '2019-07-23 21:30:09', '1', '2019-07-23 21:30:09', '短信', '71', '0'), ('73', '1', '2019-07-23 21:30:09', '1', '2019-07-23 21:30:09', '邮件', '71', '1'), ('80', '1', '2019-09-07 14:44:04', '1', '2019-09-07 14:44:04', '通信方式', '0', '0'), ('81', '1', '2019-09-07 14:44:04', '1', '2019-09-07 14:44:04', 'TCP/IP', '80', '1'), ('82', '1', '2019-09-07 14:47:33', '1', '2019-09-07 14:47:33', '区域', '0', '0'), ('83', '1', '2019-09-07 14:47:33', '1', '2019-09-07 14:47:33', 'A区', '82', '1'), ('84', '1', '2019-09-07 14:47:33', '1', '2019-09-07 14:47:33', 'B区', '82', '2'), ('85', '1', '2019-09-08 10:35:52', '1', '2019-09-08 10:35:52', '门禁设备类型', '0', '0'), ('86', '1', '2019-09-08 10:35:52', '1', '2019-09-08 10:35:52', '单门控制器', '85', '1'), ('87', '1', '2019-09-08 10:35:52', '1', '2019-09-08 10:35:52', '双门控制器', '85', '2'), ('88', '1', '2019-09-08 10:35:52', '1', '2019-09-08 10:35:52', '四门控制器', '85', '4');
COMMIT;

-- ----------------------------
--  Table structure for `t_sys_file_info`
-- ----------------------------
DROP TABLE IF EXISTS `t_sys_file_info`;
CREATE TABLE `t_sys_file_info` (
  `ID` bigint(19) NOT NULL AUTO_INCREMENT,
  `CREATE_BY` bigint(19) DEFAULT NULL COMMENT '创建人',
  `CREATE_TIME` datetime DEFAULT NULL COMMENT '创建时间/注册时间',
  `MODIFY_BY` bigint(19) DEFAULT NULL COMMENT '最后更新人',
  `MODIFY_TIME` datetime DEFAULT NULL COMMENT '最后更新时间',
  `ORIGINAL_FILE_NAME` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `REAL_FILE_NAME` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  PRIMARY KEY (`ID`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin ROW_FORMAT=DYNAMIC;

-- ----------------------------
--  Table structure for `t_sys_login_log`
-- ----------------------------
DROP TABLE IF EXISTS `t_sys_login_log`;
CREATE TABLE `t_sys_login_log` (
  `ID` int(10) NOT NULL AUTO_INCREMENT,
  `CREATE_TIME` datetime DEFAULT NULL COMMENT '创建时间',
  `IP` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `LOGNAME` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `MESSAGE` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `SUCCEED` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `USERID` int(10) DEFAULT NULL,
  PRIMARY KEY (`ID`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=179 DEFAULT CHARSET=utf8 COLLATE=utf8_bin ROW_FORMAT=DYNAMIC COMMENT='登录日志';

-- ----------------------------
--  Records of `t_sys_login_log`
-- ----------------------------
BEGIN;
INSERT INTO `t_sys_login_log` VALUES ('71', '2019-05-10 13:17:43', '127.0.0.1', '登录日志', null, '成功', '1'), ('72', '2019-05-12 13:36:56', '127.0.0.1', '登录日志', null, '成功', '1'), ('73', '2019-09-07 12:59:32', '0:0:0:0:0:0:0:1', '登录日志', null, '成功', '1'), ('74', '2019-09-07 13:48:33', '0:0:0:0:0:0:0:1', '登录日志', null, '成功', '1'), ('75', '2019-09-07 13:54:52', '0:0:0:0:0:0:0:1', '退出日志', null, '成功', '1'), ('76', '2019-09-07 13:54:53', '0:0:0:0:0:0:0:1', '登录日志', null, '成功', '1'), ('77', '2019-09-07 14:28:24', '0:0:0:0:0:0:0:1', '登录日志', null, '成功', '1'), ('78', '2019-09-07 14:46:52', '0:0:0:0:0:0:0:1', '退出日志', null, '成功', '1'), ('79', '2019-09-07 14:46:54', '0:0:0:0:0:0:0:1', '登录日志', null, '成功', '1'), ('80', '2019-09-07 14:50:54', '0:0:0:0:0:0:0:1', '退出日志', null, '成功', '1'), ('81', '2019-09-07 14:50:56', '0:0:0:0:0:0:0:1', '登录日志', null, '成功', '1'), ('82', '2019-09-07 14:51:44', '0:0:0:0:0:0:0:1', '退出日志', null, '成功', '1'), ('83', '2019-09-07 14:51:46', '0:0:0:0:0:0:0:1', '登录日志', null, '成功', '1'), ('84', '2019-09-07 14:52:58', '0:0:0:0:0:0:0:1', '退出日志', null, '成功', '1'), ('85', '2019-09-07 15:00:21', '0:0:0:0:0:0:0:1', '登录日志', null, '成功', '1'), ('86', '2019-09-07 15:13:45', '0:0:0:0:0:0:0:1', '登录日志', null, '成功', '1'), ('87', '2019-09-07 15:27:04', '0:0:0:0:0:0:0:1', '登录日志', null, '成功', '1'), ('88', '2019-09-07 15:31:48', '0:0:0:0:0:0:0:1', '登录日志', null, '成功', '1'), ('89', '2019-09-08 00:35:02', '0:0:0:0:0:0:0:1', '登录日志', null, '成功', '1'), ('90', '2019-09-08 01:01:48', '0:0:0:0:0:0:0:1', '登录日志', null, '成功', '1'), ('91', '2019-09-08 01:56:52', '0:0:0:0:0:0:0:1', '登录日志', null, '成功', '1'), ('92', '2019-09-08 01:59:44', '0:0:0:0:0:0:0:1', '登录日志', null, '成功', '1'), ('93', '2019-09-08 02:38:28', '0:0:0:0:0:0:0:1', '登录日志', null, '成功', '1'), ('94', '2019-09-08 02:46:59', '0:0:0:0:0:0:0:1', '登录日志', null, '成功', '1'), ('95', '2019-09-08 02:49:04', '0:0:0:0:0:0:0:1', '退出日志', null, '成功', '1'), ('96', '2019-09-08 02:49:10', '0:0:0:0:0:0:0:1', '登录日志', null, '成功', '1'), ('97', '2019-09-08 02:51:23', '0:0:0:0:0:0:0:1', '登录日志', null, '成功', '1'), ('98', '2019-09-08 02:53:05', '0:0:0:0:0:0:0:1', '登录日志', null, '成功', '1'), ('99', '2019-09-08 03:10:45', '0:0:0:0:0:0:0:1', '登录日志', null, '成功', '1'), ('100', '2019-09-08 03:16:07', '0:0:0:0:0:0:0:1', '登录日志', null, '成功', '1'), ('101', '2019-09-08 03:48:40', '0:0:0:0:0:0:0:1', '登录日志', null, '成功', '1'), ('102', '2019-09-08 04:04:10', '0:0:0:0:0:0:0:1', '登录日志', null, '成功', '1'), ('103', '2019-09-08 04:15:38', '0:0:0:0:0:0:0:1', '登录日志', null, '成功', '1'), ('104', '2019-09-08 04:58:49', '0:0:0:0:0:0:0:1', '登录日志', null, '成功', '1'), ('105', '2019-09-08 05:04:18', '0:0:0:0:0:0:0:1', '登录日志', null, '成功', '1'), ('106', '2019-09-08 05:10:24', '0:0:0:0:0:0:0:1', '登录日志', null, '成功', '1'), ('107', '2019-09-08 05:14:08', '0:0:0:0:0:0:0:1', '退出日志', null, '成功', '1'), ('108', '2019-09-08 05:14:10', '0:0:0:0:0:0:0:1', '登录日志', null, '成功', '1'), ('109', '2019-09-08 05:16:46', '0:0:0:0:0:0:0:1', '登录日志', null, '成功', '1'), ('110', '2019-09-08 05:18:08', '0:0:0:0:0:0:0:1', '登录日志', null, '成功', '1'), ('111', '2019-09-08 05:21:12', '0:0:0:0:0:0:0:1', '登录日志', null, '成功', '1'), ('112', '2019-09-08 05:27:03', '0:0:0:0:0:0:0:1', '登录日志', null, '成功', '1'), ('113', '2019-09-08 05:29:56', '0:0:0:0:0:0:0:1', '登录日志', null, '成功', '1'), ('114', '2019-09-08 05:31:04', '0:0:0:0:0:0:0:1', '退出日志', null, '成功', '1'), ('115', '2019-09-08 05:31:06', '0:0:0:0:0:0:0:1', '登录日志', null, '成功', '1'), ('116', '2019-09-08 05:48:46', '0:0:0:0:0:0:0:1', '登录日志', null, '成功', '1'), ('117', '2019-09-08 05:54:38', '0:0:0:0:0:0:0:1', '登录日志', null, '成功', '1'), ('118', '2019-09-08 05:57:34', '0:0:0:0:0:0:0:1', '登录日志', null, '成功', '1'), ('119', '2019-09-08 06:04:32', '0:0:0:0:0:0:0:1', '登录日志', null, '成功', '1'), ('120', '2019-09-08 06:07:21', '0:0:0:0:0:0:0:1', '退出日志', null, '成功', '1'), ('121', '2019-09-08 06:07:23', '0:0:0:0:0:0:0:1', '登录日志', null, '成功', '1'), ('122', '2019-09-08 06:19:47', '0:0:0:0:0:0:0:1', '登录日志', null, '成功', '1'), ('123', '2019-09-08 06:25:17', '0:0:0:0:0:0:0:1', '登录日志', null, '成功', '1'), ('124', '2019-09-08 06:26:56', '0:0:0:0:0:0:0:1', '登录日志', null, '成功', '1'), ('125', '2019-09-08 06:31:38', '0:0:0:0:0:0:0:1', '登录日志', null, '成功', '1'), ('126', '2019-09-08 06:33:42', '0:0:0:0:0:0:0:1', '登录日志', null, '成功', '1'), ('127', '2019-09-08 06:43:03', '0:0:0:0:0:0:0:1', '登录日志', null, '成功', '1'), ('128', '2019-09-08 06:53:04', '0:0:0:0:0:0:0:1', '登录日志', null, '成功', '1'), ('129', '2019-09-08 07:06:49', '0:0:0:0:0:0:0:1', '登录日志', null, '成功', '1'), ('130', '2019-09-08 07:16:33', '0:0:0:0:0:0:0:1', '登录日志', null, '成功', '1'), ('131', '2019-09-08 07:18:59', '0:0:0:0:0:0:0:1', '登录日志', null, '成功', '1'), ('132', '2019-09-08 10:34:28', '0:0:0:0:0:0:0:1', '登录日志', null, '成功', '1'), ('133', '2019-09-08 11:36:00', '0:0:0:0:0:0:0:1', '登录日志', null, '成功', '1'), ('134', '2019-09-08 12:19:26', '0:0:0:0:0:0:0:1', '登录日志', null, '成功', '1'), ('135', '2019-09-08 12:26:26', '0:0:0:0:0:0:0:1', '退出日志', null, '成功', '1'), ('136', '2019-09-08 12:26:28', '0:0:0:0:0:0:0:1', '登录日志', null, '成功', '1'), ('137', '2019-09-08 14:22:12', '0:0:0:0:0:0:0:1', '登录日志', null, '成功', '1'), ('138', '2019-09-08 14:33:07', '0:0:0:0:0:0:0:1', '登录日志', null, '成功', '1'), ('139', '2019-09-08 14:51:05', '0:0:0:0:0:0:0:1', '登录日志', null, '成功', '1'), ('140', '2019-09-09 11:05:45', '0:0:0:0:0:0:0:1', '登录日志', null, '成功', '1'), ('141', '2019-09-09 11:20:51', '0:0:0:0:0:0:0:1', '退出日志', null, '成功', '1'), ('142', '2019-09-09 11:20:53', '0:0:0:0:0:0:0:1', '登录日志', null, '成功', '1'), ('143', '2019-09-09 13:02:47', '0:0:0:0:0:0:0:1', '登录日志', null, '成功', '1'), ('144', '2019-09-09 13:21:10', '0:0:0:0:0:0:0:1', '登录日志', null, '成功', '1'), ('145', '2019-09-09 14:43:23', '0:0:0:0:0:0:0:1', '登录日志', null, '成功', '1'), ('146', '2019-09-09 15:31:29', '0:0:0:0:0:0:0:1', '登录日志', null, '成功', '1'), ('147', '2019-09-10 10:38:22', '0:0:0:0:0:0:0:1', '登录日志', null, '成功', '1'), ('148', '2019-09-10 11:54:08', '0:0:0:0:0:0:0:1', '登录日志', null, '成功', '1'), ('149', '2019-09-10 13:34:29', '0:0:0:0:0:0:0:1', '登录日志', null, '成功', '1'), ('150', '2019-09-10 13:44:26', '0:0:0:0:0:0:0:1', '登录日志', null, '成功', '1'), ('151', '2019-09-10 14:20:37', '0:0:0:0:0:0:0:1', '登录日志', null, '成功', '1'), ('152', '2019-09-11 10:50:08', '0:0:0:0:0:0:0:1', '登录日志', null, '成功', '1'), ('153', '2019-09-11 12:27:07', '0:0:0:0:0:0:0:1', '登录日志', null, '成功', '1'), ('154', '2019-09-11 12:50:22', '0:0:0:0:0:0:0:1', '登录日志', null, '成功', '1'), ('155', '2019-09-11 14:04:49', '0:0:0:0:0:0:0:1', '登录日志', null, '成功', '1'), ('156', '2019-09-11 14:12:24', '0:0:0:0:0:0:0:1', '登录日志', null, '成功', '1'), ('157', '2019-09-11 14:17:01', '0:0:0:0:0:0:0:1', '登录日志', null, '成功', '1'), ('158', '2019-09-11 14:19:04', '0:0:0:0:0:0:0:1', '登录日志', null, '成功', '1'), ('159', '2019-09-11 14:26:03', '0:0:0:0:0:0:0:1', '登录日志', null, '成功', '1'), ('160', '2019-09-11 14:30:32', '0:0:0:0:0:0:0:1', '登录日志', null, '成功', '1'), ('161', '2019-09-11 14:41:33', '0:0:0:0:0:0:0:1', '登录日志', null, '成功', '1'), ('162', '2019-09-11 14:55:18', '0:0:0:0:0:0:0:1', '登录日志', null, '成功', '1'), ('163', '2019-09-11 14:57:35', '0:0:0:0:0:0:0:1', '登录日志', null, '成功', '1'), ('164', '2019-09-12 11:38:55', '0:0:0:0:0:0:0:1', '登录日志', null, '成功', '1'), ('165', '2019-09-14 03:22:47', '0:0:0:0:0:0:0:1', '登录日志', null, '成功', '1'), ('166', '2019-09-14 03:30:52', '0:0:0:0:0:0:0:1', '退出日志', null, '成功', '1'), ('167', '2019-09-14 03:30:54', '0:0:0:0:0:0:0:1', '登录日志', null, '成功', '1'), ('168', '2019-09-14 04:08:42', '0:0:0:0:0:0:0:1', '登录日志', null, '成功', '1'), ('169', '2019-09-14 04:08:42', '0:0:0:0:0:0:0:1', '登录日志', null, '成功', '1'), ('170', '2019-09-14 05:40:55', '0:0:0:0:0:0:0:1', '登录日志', null, '成功', '1'), ('171', '2019-09-14 05:48:39', '0:0:0:0:0:0:0:1', '登录日志', null, '成功', '1'), ('172', '2019-09-14 06:51:24', '0:0:0:0:0:0:0:1', '登录日志', null, '成功', '1'), ('173', '2019-09-14 07:12:11', '0:0:0:0:0:0:0:1', '登录日志', null, '成功', '1'), ('174', '2019-09-14 07:42:59', '0:0:0:0:0:0:0:1', '登录日志', null, '成功', '1'), ('175', '2019-09-14 07:51:16', '0:0:0:0:0:0:0:1', '登录日志', null, '成功', '1'), ('176', '2019-09-14 08:33:11', '0:0:0:0:0:0:0:1', '登录日志', null, '成功', '1'), ('177', '2019-09-16 06:40:32', '127.0.0.1', '登录日志', null, '成功', '1'), ('178', '2019-09-16 07:02:12', '127.0.0.1', '登录日志', null, '成功', '1');
COMMIT;

-- ----------------------------
--  Table structure for `t_sys_menu`
-- ----------------------------
DROP TABLE IF EXISTS `t_sys_menu`;
CREATE TABLE `t_sys_menu` (
  `ID` bigint(19) NOT NULL AUTO_INCREMENT,
  `CREATE_BY` bigint(19) DEFAULT NULL COMMENT '创建人',
  `CREATE_TIME` datetime DEFAULT NULL COMMENT '创建时间/注册时间',
  `MODIFY_BY` bigint(19) DEFAULT NULL COMMENT '最后更新人',
  `MODIFY_TIME` datetime DEFAULT NULL COMMENT '最后更新时间',
  `CODE` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `ICON` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `ISMENU` int(10) DEFAULT NULL,
  `ISOPEN` int(10) DEFAULT NULL,
  `LEVELS` int(10) DEFAULT NULL,
  `NAME` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `NUM` int(10) DEFAULT NULL,
  `PCODE` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `PCODES` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `STATUS` int(10) DEFAULT NULL,
  `TIPS` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `URL` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  PRIMARY KEY (`ID`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=191 DEFAULT CHARSET=utf8 COLLATE=utf8_bin ROW_FORMAT=DYNAMIC COMMENT='菜单';

-- ----------------------------
--  Records of `t_sys_menu`
-- ----------------------------
BEGIN;
INSERT INTO `t_sys_menu` VALUES ('1', null, null, null, null, 'system', 'fa-cog', '1', '1', '1', '系统管理', '4', '0', '[0],', '1', null, '/system'), ('3', null, null, '47', '2019-06-02 10:09:09', 'operationMgr', 'fa-wrench', '1', null, '1', '运维管理', '3', '0', '[0],', '1', null, '/optionMgr'), ('4', null, null, '1', '2019-04-16 18:59:15', 'mgr', '', '1', null, '2', '用户管理', '1', 'system', '[0],[system],', '1', null, '/mgr'), ('5', null, null, null, null, 'mgr_add', '', '0', null, '3', '添加用户', '1', 'mgr', '[0],[system],[mgr],', '1', null, '/mgr/add'), ('6', null, null, null, null, 'mgr_edit', '', '0', null, '3', '修改用户', '2', 'mgr', '[0],[system],[mgr],', '1', null, '/mgr/edit'), ('7', null, null, null, null, 'mgr_delete', '', '0', '0', '3', '删除用户', '3', 'mgr', '[0],[system],[mgr],', '1', null, '/mgr/delete'), ('8', null, null, null, null, 'mgr_reset', '', '0', '0', '3', '重置密码', '4', 'mgr', '[0],[system],[mgr],', '1', null, '/mgr/reset'), ('9', null, null, null, null, 'mgr_freeze', '', '0', '0', '3', '冻结用户', '5', 'mgr', '[0],[system],[mgr],', '1', null, '/mgr/freeze'), ('10', null, null, null, null, 'mgr_unfreeze', '', '0', '0', '3', '解除冻结用户', '6', 'mgr', '[0],[system],[mgr],', '1', null, '/mgr/unfreeze'), ('11', null, null, null, null, 'mgr_setRole', '', '0', '0', '3', '分配角色', '7', 'mgr', '[0],[system],[mgr],', '1', null, '/mgr/setRole'), ('12', null, null, null, null, 'role', '', '1', '0', '2', '角色管理', '2', 'system', '[0],[system],', '1', null, '/role'), ('13', null, null, null, null, 'role_add', '', '0', '0', '3', '添加角色', '1', 'role', '[0],[system],[role],', '1', null, '/role/add'), ('14', null, null, null, null, 'role_edit', '', '0', '0', '3', '修改角色', '2', 'role', '[0],[system],[role],', '1', null, '/role/edit'), ('15', null, null, null, null, 'role_remove', '', '0', '0', '3', '删除角色', '3', 'role', '[0],[system],[role],', '1', null, '/role/remove'), ('16', null, null, null, null, 'role_setAuthority', '', '0', '0', '3', '配置权限', '4', 'role', '[0],[system],[role],', '1', null, '/role/setAuthority'), ('17', null, null, null, null, 'menu', '', '1', '0', '2', '菜单管理', '4', 'system', '[0],[system],', '1', null, '/menu'), ('18', null, null, null, null, 'menu_add', '', '0', '0', '3', '添加菜单', '1', 'menu', '[0],[system],[menu],', '1', null, '/menu/add'), ('19', null, null, null, null, 'menu_edit', '', '0', '0', '3', '修改菜单', '2', 'menu', '[0],[system],[menu],', '1', null, '/menu/edit'), ('20', null, null, null, null, 'menu_remove', '', '0', '0', '3', '删除菜单', '3', 'menu', '[0],[system],[menu],', '1', null, '/menu/remove'), ('21', null, null, null, null, 'dept', '', '1', null, '2', '部门管理', '3', 'system', '[0],[system],', '1', null, '/dept'), ('22', null, null, null, null, 'dict', '', '1', null, '2', '字典管理', '4', 'system', '[0],[system],', '1', null, '/dict'), ('23', null, null, null, null, 'dept_update', '', '0', null, '3', '修改部门', '1', 'dept', '[0],[system],[dept],', '1', null, '/dept/update'), ('24', null, null, null, null, 'dept_delete', '', '0', null, '3', '删除部门', '1', 'dept', '[0],[system],[dept],', '1', null, '/dept/delete'), ('25', null, null, null, null, 'dict_add', '', '0', null, '3', '添加字典', '1', 'dict', '[0],[system],[dict],', '1', null, '/dict/add'), ('26', null, null, null, null, 'dict_update', '', '0', null, '3', '修改字典', '1', 'dict', '[0],[system],[dict],', '1', null, '/dict/update'), ('27', null, null, null, null, 'dict_delete', '', '0', null, '3', '删除字典', '1', 'dict', '[0],[system],[dict],', '1', null, '/dict/delete'), ('28', null, null, null, null, 'to_menu_edit', '', '0', null, '3', '菜单编辑跳转', '4', 'menu', '[0],[system],[menu],', '1', null, '/menu/menu_edit'), ('29', null, null, null, null, 'menu_list', '', '0', null, '3', '菜单列表', '5', 'menu', '[0],[system],[menu],', '1', null, '/menu/list'), ('30', null, null, null, null, 'to_dept_update', '', '0', null, '3', '修改部门跳转', '4', 'dept', '[0],[system],[dept],', '1', null, '/dept/dept_update'), ('31', null, null, null, null, 'dept_list', '', '0', null, '3', '部门列表', '5', 'dept', '[0],[system],[dept],', '1', null, '/dept/list'), ('32', null, null, null, null, 'dept_detail', '', '0', null, '3', '部门详情', '6', 'dept', '[0],[system],[dept],', '1', null, '/dept/detail'), ('33', null, null, null, null, 'to_dict_edit', '', '0', null, '3', '修改菜单跳转', '4', 'dict', '[0],[system],[dict],', '1', null, '/dict/dict_edit'), ('34', null, null, null, null, 'dict_list', '', '0', null, '3', '字典列表', '5', 'dict', '[0],[system],[dict],', '1', null, '/dict/list'), ('35', null, null, null, null, 'dict_detail', '', '0', null, '3', '字典详情', '6', 'dict', '[0],[system],[dict],', '1', null, '/dict/detail'), ('36', null, null, null, null, 'dept_add', '', '0', null, '3', '添加部门', '1', 'dept', '[0],[system],[dept],', '1', null, '/dept/add'), ('37', null, null, null, null, 'to_role_edit', '', '0', null, '3', '修改角色跳转', '5', 'role', '[0],[system],[role],', '1', null, '/role/role_edit'), ('38', null, null, null, null, 'to_role_assign', '', '0', null, '3', '角色分配跳转', '6', 'role', '[0],[system],[role],', '1', null, '/role/role_assign'), ('39', null, null, null, null, 'role_list', '', '0', null, '3', '角色列表', '7', 'role', '[0],[system],[role],', '1', null, '/role/list'), ('40', null, null, null, null, 'to_assign_role', '', '0', null, '3', '分配角色跳转', '8', 'mgr', '[0],[system],[mgr],', '1', null, '/mgr/role_assign'), ('41', null, null, null, null, 'to_user_edit', '', '0', null, '3', '编辑用户跳转', '9', 'mgr', '[0],[system],[mgr],', '1', null, '/mgr/user_edit'), ('42', null, null, null, null, 'mgr_list', '', '0', null, '3', '用户列表', '10', 'mgr', '[0],[system],[mgr],', '1', null, '/mgr/list'), ('43', null, null, null, null, 'cfg', '', '1', null, '2', '参数管理', '10', 'system', '[0],[system],', '1', null, '/cfg'), ('44', null, null, null, null, 'cfg_add', '', '0', null, '3', '添加系统参数', '1', 'cfg', '[0],[system],[cfg],', '1', null, '/cfg/add'), ('45', null, null, null, null, 'cfg_update', '', '0', null, '3', '修改系统参数', '2', 'cfg', '[0],[system],[cfg],', '1', null, '/cfg/update'), ('46', null, null, null, null, 'cfg_delete', '', '0', null, '3', '删除系统参数', '3', 'cfg', '[0],[system],[cfg],', '1', null, '/cfg/delete'), ('47', null, null, null, null, 'task', '', '1', null, '2', '任务管理', '11', 'system', '[0],[system],', '1', null, '/task'), ('48', null, null, null, null, 'task_add', '', '0', null, '3', '添加任务', '1', 'task', '[0],[system],[task],', '1', null, '/task/add'), ('49', null, null, null, null, 'task_update', '', '0', null, '3', '修改任务', '2', 'task', '[0],[system],[task],', '1', null, '/task/update'), ('50', null, null, null, null, 'task_delete', '', '0', null, '3', '删除任务', '3', 'task', '[0],[system],[task],', '1', null, '/task/delete'), ('56', '1', '2019-03-11 22:30:17', '1', '2019-03-11 22:30:17', 'editArticle', '', '1', null, '3', '编辑文章', '1', 'article', '[0],[cms],[article]', '1', null, '/article/edit'), ('58', null, null, '47', '2019-06-02 10:25:31', 'log', null, '1', null, '2', '业务日志', '6', 'operationMgr', '[0],[operationMgr],', '1', null, '/log'), ('59', null, null, '47', '2019-06-02 10:25:36', 'loginLog', null, '1', null, '2', '登录日志', '6', 'operationMgr', '[0],[operationMgr],', '1', null, '/loginLog'), ('60', null, null, null, null, 'log_clean', '', '0', null, '3', '清空日志', '3', 'log', '[0],[system],[log],', '1', null, '/log/delLog'), ('61', null, null, null, null, 'log_detail', '', '0', null, '3', '日志详情', '3', 'log', '[0],[system],[log],', '1', null, '/log/detail'), ('62', null, null, null, null, 'del_login_log', '', '0', null, '3', '清空登录日志', '1', 'loginLog', '[0],[system],[loginLog],', '1', null, '/loginLog/delLoginLog'), ('63', null, null, null, null, 'login_log_list', '', '0', null, '3', '登录日志列表', '2', 'loginLog', '[0],[system],[loginLog],', '1', null, '/loginLog/list'), ('64', '47', '2019-06-02 10:10:20', '47', '2019-06-02 10:10:20', 'druid', '', '1', null, '2', '数据库监控', '1', 'operationMgr', '[0],[operationMgr],', '1', null, '/druid'), ('65', '47', '2019-06-02 10:10:20', '47', '2019-06-02 10:10:20', 'swagger', null, '1', null, '2', '接口文档', '2', 'operationMgr', '[0],[operationMgr],', '1', null, '/swagger-ui.html'), ('66', '1', '2019-06-10 21:26:52', '1', '2019-06-10 21:26:52', 'messageMgr', 'fa-envelope-o', '1', null, '1', '消息管理', '5', '0', '[0],', '1', null, '/message'), ('67', '1', '2019-06-10 21:27:34', '1', '2019-06-10 21:27:34', 'historyMessage', null, '1', null, '2', '历史消息', '1', 'messageMgr', '[0],[messageMgr],', '1', null, '/message/history'), ('68', '1', '2019-06-10 21:27:56', '1', '2019-06-10 21:27:56', 'messageTemplate', null, '1', null, '2', '消息模板', '2', 'messageMgr', '[0],[messageMgr],', '1', null, '/message/template'), ('69', '1', '2019-06-10 21:28:21', '1', '2019-06-10 21:28:21', 'messageSender', null, '1', null, '2', '消息发送器', '3', 'messageMgr', '[0],[messageMgr],', '1', null, '/message/sender'), ('70', null, null, '1', '2019-09-07 13:52:39', 'equipment', '', '1', null, '1', '设备', '6', '0', '[0],', '1', null, '/door'), ('71', null, null, '1', '2019-09-14 03:31:25', 'equipment_list', '', '1', null, '2', '设备管理', '1', 'equipment', '[0],[equipment],', '1', null, '/door/EQUIPMENT/INFO'), ('72', '1', '2019-09-07 13:53:10', '1', '2019-09-07 13:53:10', 'equipment_add', '', '0', null, '3', '添加设备', '1', 'equipment_list', '[0],[equipment],[equipment_list],', '1', null, '/door/EQUIPMENT/INFO/add'), ('73', '1', '2019-09-07 13:53:35', '1', '2019-09-07 13:53:35', 'equipment_update', '', '0', null, '3', '设备修改', '2', 'equipment_list', '[0],[equipment],[equipment_list],', '1', null, '/door/EQUIPMENT/INFO/update'), ('74', '1', '2019-09-07 13:54:08', '1', '2019-09-07 13:54:08', 'equipment_delete', '', '0', null, '3', '设备删除', '3', 'equipment_list', '[0],[equipment],[equipment_list],', '1', null, '/door/EQUIPMENT/INFO/delete'), ('75', '1', '2019-09-08 12:23:14', '1', '2019-09-08 12:23:14', 'EntranceGuard', '', '1', null, '1', '门禁', '7', '0', '[0],', '1', null, '/entrance/guard'), ('76', '1', '2019-09-08 12:24:19', '1', '2019-09-08 12:24:19', 'door_door_info', '', '1', null, '2', '门设置', '1', 'EntranceGuard', '[0],[EntranceGuard],', '1', null, '/door/DOOR/INFO'), ('77', '1', '2019-09-08 12:25:19', '1', '2019-09-08 12:25:19', 'door_door_info_update', '', '0', null, '3', '门修改', '1', 'door_door_info', '[0],[EntranceGuard],[door_door_info],', '1', null, '/door/DOOR/INFO/update'), ('78', '1', '2019-09-09 11:16:09', '1', '2019-09-09 11:16:09', 'base_setting', '', '1', null, '1', '基本设置', '8', '0', '[0],', '1', null, '/door/base'), ('79', '1', '2019-09-09 11:17:23', '1', '2019-09-09 11:17:23', 'door_entrance_guard_rule', '', '1', null, '2', '门禁权限', '1', 'base_setting', '[0],[base_setting],', '1', null, '/door/ENTRANCE/GUARD/RULE'), ('80', null, null, '1', '2019-09-09 11:18:32', 'door_entrance_guard_rule_add', '', '0', null, '3', '门禁权限新增', '1', 'door_entrance_guard_rule', '[0],[base_setting],[door_entrance_guard_rule],', '1', null, '/door/ENTRANCE/GUARD/RULE/add'), ('81', '1', '2019-09-09 11:20:03', '1', '2019-09-09 11:20:03', 'door_entrance_guard_rule_update', '', '0', null, '3', '门禁权限修改', '2', 'door_entrance_guard_rule', '[0],[base_setting],[door_entrance_guard_rule],', '1', null, '/door/ENTRANCE/GUARD/RULE/update'), ('82', '1', '2019-09-09 11:20:33', '1', '2019-09-09 11:20:33', 'door_entrance_guard_rule_delete', '', '0', null, '3', '门禁权限删除', '3', 'door_entrance_guard_rule', '[0],[base_setting],[door_entrance_guard_rule],', '1', null, '/door/ENTRANCE/GUARD/RULE/delete'), ('83', null, null, '1', '2019-09-14 04:08:59', 'door_search_device', '', '1', null, '2', '搜索设备', '2', 'equipment', '[0],[equipment],', '1', null, '/door/device/mgr'), ('183', '1', '2019-09-10 06:41:20', '1', '2019-09-10 06:41:20', 't_entrance_gard_user', '', '1', null, '2', '人员权限', '2', 'base_setting', '[0],[base_setting],', '1', null, '/door/ENTRANCE/GARD/USER'), ('184', null, null, '1', '2019-09-10 06:56:51', 't_entrance_gard_user_add', '', '0', null, '3', '人员权限添加', '1', 't_entrance_gard_user', '[0],[base_setting],[t_entrance_gard_user],', '1', null, '/door/ENTRANCE/GARD/USER/add'), ('185', '1', '2019-09-10 06:46:43', '1', '2019-09-10 06:46:43', 't_entrance_gard_user_update', '', '0', null, '3', '人员权限修改', '2', 't_entrance_gard_user', '[0],[base_setting],[t_entrance_gard_user],', '1', null, '/door/ENTRANCE/GARD/USER/update'), ('186', '1', '2019-09-10 06:47:49', '1', '2019-09-10 06:47:49', 't_entrance_gard_user_delete', '', '0', null, '3', '人员权限删除', '3', 't_entrance_gard_user', '[0],[base_setting],[t_entrance_gard_user],', '1', null, '/door/ENTRANCE/GARD/USER/delete'), ('187', '1', '2019-09-16 06:55:51', '1', '2019-09-16 06:55:51', 'door_user_card', '', '1', null, '2', '批量发卡', '3', 'EntranceGuard', '[0],[EntranceGuard],', '1', null, '/door/USER/CARD'), ('188', '1', '2019-09-16 06:56:48', '1', '2019-09-16 06:56:48', 'door_user_card_add', '', '0', null, '3', '添加', '1', 'door_user_card', '[0],[EntranceGuard],[door_user_card],', '1', null, '/door/USER/CARD/add'), ('189', '1', '2019-09-16 06:57:35', '1', '2019-09-16 06:57:35', 'door_user_card_update', '', '0', null, '3', '修改', '2', 'door_user_card', '[0],[EntranceGuard],[door_user_card],', '1', null, '/door/USER/CARD/update'), ('190', '1', '2019-09-16 06:58:21', '1', '2019-09-16 06:58:21', 'door_user_card_delete', '', '0', null, '3', '删除', '3', 'door_user_card', '[0],[EntranceGuard],[door_user_card],', '1', null, '/door/USER/CARD/delete');
COMMIT;

-- ----------------------------
--  Table structure for `t_sys_notice`
-- ----------------------------
DROP TABLE IF EXISTS `t_sys_notice`;
CREATE TABLE `t_sys_notice` (
  `ID` bigint(19) NOT NULL AUTO_INCREMENT,
  `CREATE_BY` bigint(19) DEFAULT NULL COMMENT '创建人',
  `CREATE_TIME` datetime DEFAULT NULL COMMENT '创建时间/注册时间',
  `MODIFY_BY` bigint(19) DEFAULT NULL COMMENT '最后更新人',
  `MODIFY_TIME` datetime DEFAULT NULL COMMENT '最后更新时间',
  `CONTENT` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `TITLE` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `TYPE` int(10) DEFAULT NULL,
  PRIMARY KEY (`ID`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_bin ROW_FORMAT=DYNAMIC COMMENT='系统通知';

-- ----------------------------
--  Records of `t_sys_notice`
-- ----------------------------
BEGIN;
INSERT INTO `t_sys_notice` VALUES ('1', '1', '2017-01-11 08:53:20', '1', '2019-01-08 23:30:58', '欢迎使用guns-lite后台管理系统，点击查看<a href=\"http://enilu.gitee.io/guns-lite\" target=\"_blank\">官方文档</a>', '世界', '10');
COMMIT;

-- ----------------------------
--  Table structure for `t_sys_operation_log`
-- ----------------------------
DROP TABLE IF EXISTS `t_sys_operation_log`;
CREATE TABLE `t_sys_operation_log` (
  `ID` bigint(19) NOT NULL AUTO_INCREMENT,
  `CLASSNAME` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `CREATE_TIME` datetime DEFAULT NULL,
  `LOGNAME` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `LOGTYPE` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `MESSAGE` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `METHOD` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `SUCCEED` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `USERID` int(10) DEFAULT NULL,
  PRIMARY KEY (`ID`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=218 DEFAULT CHARSET=utf8 COLLATE=utf8_bin ROW_FORMAT=DYNAMIC COMMENT='操作日志';

-- ----------------------------
--  Records of `t_sys_operation_log`
-- ----------------------------
BEGIN;
INSERT INTO `t_sys_operation_log` VALUES ('76', 'cn.enilu.guns.api.controller.cms.ArticleMgrController', '2019-05-10 13:22:49', '编辑文章', '业务日志', '名称=null;;;', 'upload', '成功', '1'), ('77', 'cn.enilu.guns.api.controller.cms.ArticleMgrController', '2019-05-10 13:31:09', '编辑文章', '业务日志', '名称=null;;;', 'upload', '成功', '1'), ('78', 'cn.enilu.guns.admin.modular.system.controller.MenuController', '2019-09-07 13:50:25', '菜单新增', '业务日志', '菜单名称=设备管理', 'add', '成功', '1'), ('79', 'cn.enilu.guns.admin.modular.system.controller.MenuController', '2019-09-07 13:51:10', '菜单新增', '业务日志', '菜单名称=设备管理', 'add', '成功', '1'), ('80', 'cn.enilu.guns.admin.modular.system.controller.MenuController', '2019-09-07 13:51:56', '修改菜单', '业务日志', '菜单名称=设备管理;;;字段名称:菜单编号,旧值:equipment_list,新值:equipment;;;字段名称:菜单父编号,旧值:0,新值:;;;字段名称:url地址,旧值:/door/EQUIPMENT/INFO,新值:/door', 'edit', '成功', '1'), ('81', 'cn.enilu.guns.admin.modular.system.controller.MenuController', '2019-09-07 13:52:12', '修改菜单', '业务日志', '菜单名称=设备管理;;;字段名称:菜单父编号,旧值:0,新值:equipment', 'edit', '成功', '1'), ('82', 'cn.enilu.guns.admin.modular.system.controller.MenuController', '2019-09-07 13:52:22', '修改菜单', '业务日志', '菜单名称=设备管理;;;字段名称:菜单编号,旧值:equipment_list1,新值:equipment_list', 'edit', '成功', '1'), ('83', 'cn.enilu.guns.admin.modular.system.controller.MenuController', '2019-09-07 13:52:40', '修改菜单', '业务日志', '菜单名称=设备;;;字段名称:菜单父编号,旧值:0,新值:;;;字段名称:菜单名称,旧值:设备管理,新值:设备', 'edit', '成功', '1'), ('84', 'cn.enilu.guns.admin.modular.system.controller.MenuController', '2019-09-07 13:53:10', '菜单新增', '业务日志', '菜单名称=添加设备', 'add', '成功', '1'), ('85', 'cn.enilu.guns.admin.modular.system.controller.MenuController', '2019-09-07 13:53:35', '菜单新增', '业务日志', '菜单名称=设备修改', 'add', '成功', '1'), ('86', 'cn.enilu.guns.admin.modular.system.controller.MenuController', '2019-09-07 13:54:08', '菜单新增', '业务日志', '菜单名称=设备删除', 'add', '成功', '1'), ('87', 'cn.enilu.guns.admin.modular.system.controller.DictController', '2019-09-07 14:18:37', '添加字典记录', '业务日志', '字典名称=门禁设备类型,字典内容=1:单门控制器;', 'add', '成功', '1'), ('88', 'cn.enilu.guns.admin.modular.system.controller.DictController', '2019-09-07 14:40:29', '修改字典', '业务日志', '字典名称=门禁设备类型,字典内容=1:单门控制器;2:双门控制器;3:四门控制器;;;;', 'update', '成功', '1'), ('89', 'cn.enilu.guns.admin.modular.system.controller.DictController', '2019-09-07 14:44:04', '添加字典记录', '业务日志', '字典名称=通信方式,字典内容=1:TCP/IP;', 'add', '成功', '1'), ('90', 'cn.enilu.guns.admin.modular.system.controller.DictController', '2019-09-07 14:47:33', '添加字典记录', '业务日志', '字典名称=区域,字典内容=1:A区;2:B区;', 'add', '成功', '1'), ('91', 'cn.enilu.guns.admin.modular.door.EquipmentInfoController', '2019-09-07 15:31:54', '新增设备信息表', '业务日志', '名称=null', 'add', '成功', '1'), ('92', 'cn.enilu.guns.admin.modular.door.EquipmentInfoController', '2019-09-07 15:32:10', '新增设备信息表', '业务日志', '名称=null', 'add', '成功', '1'), ('93', 'cn.enilu.guns.admin.modular.door.EquipmentInfoController', '2019-09-08 00:35:36', '新增设备信息表', '业务日志', '名称=null', 'add', '成功', '1'), ('94', 'cn.enilu.guns.admin.modular.door.EquipmentInfoController', '2019-09-08 00:46:02', '新增设备信息表', '业务日志', '名称=null', 'add', '成功', '1'), ('95', 'cn.enilu.guns.admin.modular.door.EquipmentInfoController', '2019-09-08 00:46:05', '新增设备信息表', '业务日志', '名称=null', 'add', '成功', '1'), ('96', 'cn.enilu.guns.admin.modular.door.EquipmentInfoController', '2019-09-08 00:51:36', '新增设备信息表', '业务日志', '名称=null', 'add', '成功', '1'), ('97', 'cn.enilu.guns.admin.modular.door.EquipmentInfoController', '2019-09-08 00:51:39', '新增设备信息表', '业务日志', '名称=null', 'add', '成功', '1'), ('98', 'cn.enilu.guns.admin.modular.door.EquipmentInfoController', '2019-09-08 00:52:07', '新增设备信息表', '业务日志', '名称=null', 'add', '成功', '1'), ('99', 'cn.enilu.guns.admin.modular.door.EquipmentInfoController', '2019-09-08 00:52:09', '新增设备信息表', '业务日志', '名称=null', 'add', '成功', '1'), ('100', 'cn.enilu.guns.admin.modular.door.EquipmentInfoController', '2019-09-08 00:52:11', '新增设备信息表', '业务日志', '名称=null', 'add', '成功', '1'), ('101', 'cn.enilu.guns.admin.modular.door.EquipmentInfoController', '2019-09-08 01:01:55', '新增设备信息表', '业务日志', '名称=null', 'add', '成功', '1'), ('102', 'cn.enilu.guns.admin.modular.door.EquipmentInfoController', '2019-09-08 01:01:57', '新增设备信息表', '业务日志', '名称=null', 'add', '成功', '1'), ('103', 'cn.enilu.guns.admin.modular.door.EquipmentInfoController', '2019-09-08 01:02:52', '新增设备信息表', '业务日志', '名称=null', 'add', '成功', '1'), ('104', 'cn.enilu.guns.admin.modular.door.EquipmentInfoController', '2019-09-08 01:56:58', '新增设备信息表', '业务日志', '名称=null', 'add', '成功', '1'), ('105', 'cn.enilu.guns.admin.modular.door.EquipmentInfoController', '2019-09-08 01:57:00', '新增设备信息表', '业务日志', '名称=null', 'add', '成功', '1'), ('106', 'cn.enilu.guns.admin.modular.door.EquipmentInfoController', '2019-09-08 01:57:02', '新增设备信息表', '业务日志', '名称=null', 'add', '成功', '1'), ('107', 'cn.enilu.guns.admin.modular.door.EquipmentInfoController', '2019-09-08 01:57:35', '新增设备信息表', '业务日志', '名称=null', 'add', '成功', '1'), ('108', 'cn.enilu.guns.admin.modular.door.EquipmentInfoController', '2019-09-08 01:58:55', '新增设备信息表', '业务日志', '名称=null', 'add', '成功', '1'), ('109', 'cn.enilu.guns.admin.modular.door.EquipmentInfoController', '2019-09-08 01:58:57', '新增设备信息表', '业务日志', '名称=null', 'add', '成功', '1'), ('110', 'cn.enilu.guns.admin.modular.door.EquipmentInfoController', '2019-09-08 01:59:19', '新增设备信息表', '业务日志', '名称=null', 'add', '成功', '1'), ('111', 'cn.enilu.guns.admin.modular.door.EquipmentInfoController', '2019-09-08 01:59:27', '新增设备信息表', '业务日志', '名称=null', 'add', '成功', '1'), ('112', 'cn.enilu.guns.admin.modular.door.EquipmentInfoController', '2019-09-08 02:00:19', '新增设备信息表', '业务日志', '名称=null', 'add', '成功', '1'), ('113', 'cn.enilu.guns.admin.modular.door.EquipmentInfoController', '2019-09-08 03:11:28', '新增设备信息表', '业务日志', '名称=null', 'add', '成功', '1'), ('114', 'cn.enilu.guns.admin.modular.door.EquipmentInfoController', '2019-09-08 04:13:10', '新增设备信息表', '业务日志', '名称=null', 'add', '成功', '1'), ('115', 'cn.enilu.guns.admin.modular.door.EquipmentInfoController', '2019-09-08 04:16:03', '新增设备信息表', '业务日志', '名称=null', 'add', '成功', '1'), ('116', 'cn.enilu.guns.admin.modular.door.EquipmentInfoController', '2019-09-08 04:18:34', '新增设备信息表', '业务日志', '名称=null', 'add', '成功', '1'), ('117', 'cn.enilu.guns.admin.modular.door.EquipmentInfoController', '2019-09-08 05:21:29', '修改设备信息表', '业务日志', '名称=null;;;', 'update', '成功', '1'), ('118', 'cn.enilu.guns.admin.modular.door.EquipmentInfoController', '2019-09-08 05:21:37', '修改设备信息表', '业务日志', '名称=null;;;', 'update', '成功', '1'), ('119', 'cn.enilu.guns.admin.modular.door.EquipmentInfoController', '2019-09-08 05:21:48', '修改设备信息表', '业务日志', '名称=null;;;', 'update', '成功', '1'), ('120', 'cn.enilu.guns.admin.modular.door.EquipmentInfoController', '2019-09-08 05:29:04', '修改设备信息表', '业务日志', '名称=null;;;', 'update', '成功', '1'), ('121', 'cn.enilu.guns.admin.modular.door.EquipmentInfoController', '2019-09-08 05:52:21', '修改设备信息表', '业务日志', '名称=null;;;', 'update', '成功', '1'), ('122', 'cn.enilu.guns.admin.modular.door.EquipmentInfoController', '2019-09-08 05:52:28', '修改设备信息表', '业务日志', '名称=null;;;', 'update', '成功', '1'), ('123', 'cn.enilu.guns.admin.modular.door.EquipmentInfoController', '2019-09-08 06:27:15', '修改设备信息表', '业务日志', '名称=null;;;', 'update', '成功', '1'), ('124', 'cn.enilu.guns.admin.modular.door.EquipmentInfoController', '2019-09-08 10:35:06', '修改设备信息表', '业务日志', '名称=null;;;', 'update', '成功', '1'), ('125', 'cn.enilu.guns.admin.modular.system.controller.DictController', '2019-09-08 10:35:52', '修改字典', '业务日志', '字典名称=门禁设备类型,字典内容=1:单门控制器;2:双门控制器;4:四门控制器;;;;', 'update', '成功', '1'), ('126', 'cn.enilu.guns.admin.modular.door.EquipmentInfoController', '2019-09-08 10:42:56', '新增设备信息表', '业务日志', '名称=null', 'add', '成功', '1'), ('127', 'cn.enilu.guns.admin.modular.door.EquipmentInfoController', '2019-09-08 11:43:11', '新增设备信息表', '业务日志', '名称=null', 'add', '成功', '1'), ('128', 'cn.enilu.guns.admin.modular.door.EquipmentInfoController', '2019-09-08 11:44:10', '新增设备信息表', '业务日志', '名称=null', 'add', '成功', '1'), ('129', 'cn.enilu.guns.admin.modular.system.controller.MenuController', '2019-09-08 12:23:14', '菜单新增', '业务日志', '菜单名称=门禁', 'add', '成功', '1'), ('130', 'cn.enilu.guns.admin.modular.system.controller.MenuController', '2019-09-08 12:24:19', '菜单新增', '业务日志', '菜单名称=门设置', 'add', '成功', '1'), ('131', 'cn.enilu.guns.admin.modular.system.controller.MenuController', '2019-09-08 12:25:19', '菜单新增', '业务日志', '菜单名称=门修改', 'add', '成功', '1'), ('132', 'cn.enilu.guns.admin.modular.door.EquipmentInfoController', '2019-09-08 14:22:58', '新增设备信息表', '业务日志', '名称=null', 'add', '成功', '1'), ('133', 'cn.enilu.guns.admin.modular.door.DoorInfoController', '2019-09-08 14:57:14', '修改门信息', '业务日志', '名称=null;;;', 'update', '成功', '1'), ('134', 'cn.enilu.guns.admin.modular.door.DoorInfoController', '2019-09-08 14:57:22', '修改门信息', '业务日志', '名称=null;;;', 'update', '成功', '1'), ('135', 'cn.enilu.guns.admin.modular.door.DoorInfoController', '2019-09-08 15:05:31', '修改门信息', '业务日志', '名称=null;;;', 'update', '成功', '1'), ('136', 'cn.enilu.guns.admin.modular.door.DoorInfoController', '2019-09-08 15:05:39', '修改门信息', '业务日志', '名称=null;;;', 'update', '成功', '1'), ('137', 'cn.enilu.guns.admin.modular.system.controller.MenuController', '2019-09-09 11:16:09', '菜单新增', '业务日志', '菜单名称=基本设置', 'add', '成功', '1'), ('138', 'cn.enilu.guns.admin.modular.system.controller.MenuController', '2019-09-09 11:17:23', '菜单新增', '业务日志', '菜单名称=门禁权限', 'add', '成功', '1'), ('139', 'cn.enilu.guns.admin.modular.system.controller.MenuController', '2019-09-09 11:18:03', '菜单新增', '业务日志', '菜单名称=门禁权限新增', 'add', '成功', '1'), ('140', 'cn.enilu.guns.admin.modular.system.controller.MenuController', '2019-09-09 11:18:32', '修改菜单', '业务日志', '菜单名称=门禁权限新增;;;字段名称:菜单编号,旧值:1,新值:door_entrance_guard_rule_add', 'edit', '成功', '1'), ('141', 'cn.enilu.guns.admin.modular.system.controller.MenuController', '2019-09-09 11:20:03', '菜单新增', '业务日志', '菜单名称=门禁权限修改', 'add', '成功', '1'), ('142', 'cn.enilu.guns.admin.modular.system.controller.MenuController', '2019-09-09 11:20:33', '菜单新增', '业务日志', '菜单名称=门禁权限删除', 'add', '成功', '1'), ('143', 'cn.enilu.guns.admin.modular.door.EquipmentInfoController', '2019-09-09 13:08:41', '新增设备信息表', '业务日志', '名称=null', 'add', '成功', '1'), ('144', 'cn.enilu.guns.admin.modular.door.EquipmentInfoController', '2019-09-09 13:22:06', '新增设备信息表', '业务日志', '名称=null', 'add', '成功', '1'), ('145', 'cn.enilu.guns.admin.modular.door.EntranceGuardRuleController', '2019-09-09 13:27:40', '新增门禁权限', '业务日志', '名称=null', 'add', '成功', '1'), ('146', 'cn.enilu.guns.admin.modular.door.EntranceGuardRuleController', '2019-09-09 14:43:55', '新增门禁权限', '业务日志', '名称=null', 'add', '成功', '1'), ('147', 'cn.enilu.guns.admin.modular.door.EntranceGuardRuleController', '2019-09-09 14:46:53', '删除门禁权限', '业务日志', 'ID=2', 'delete', '成功', '1'), ('148', 'cn.enilu.guns.admin.modular.door.EntranceGuardRuleController', '2019-09-09 14:47:01', '修改门禁权限', '业务日志', '名称=null;;;', 'update', '成功', '1'), ('149', 'cn.enilu.guns.admin.modular.door.EntranceGuardRuleController', '2019-09-09 14:47:27', '新增门禁权限', '业务日志', '名称=null', 'add', '成功', '1'), ('150', 'cn.enilu.guns.admin.modular.door.EntranceGuardRuleController', '2019-09-09 14:49:30', '修改门禁权限', '业务日志', '名称=null;;;', 'update', '成功', '1'), ('151', 'cn.enilu.guns.admin.modular.door.DoorInfoController', '2019-09-09 15:14:25', '修改门信息', '业务日志', '名称=null;;;', 'update', '成功', '1'), ('152', 'cn.enilu.guns.admin.modular.door.DoorInfoController', '2019-09-09 15:26:41', '修改门信息', '业务日志', '名称=null;;;', 'update', '成功', '1'), ('153', 'cn.enilu.guns.admin.modular.door.DoorInfoController', '2019-09-09 15:26:48', '修改门信息', '业务日志', '名称=null;;;', 'update', '成功', '1'), ('154', 'cn.enilu.guns.admin.modular.door.EntranceGuardRuleController', '2019-09-09 15:32:39', '新增门禁权限', '业务日志', '名称=null', 'add', '成功', '1'), ('155', 'cn.enilu.guns.admin.modular.door.EntranceGuardRuleController', '2019-09-09 15:35:28', '修改门禁权限', '业务日志', '名称=null;;;', 'update', '成功', '1'), ('156', 'cn.enilu.guns.admin.modular.door.EntranceGuardRuleController', '2019-09-09 15:35:48', '修改门禁权限', '业务日志', '名称=null;;;', 'update', '成功', '1'), ('157', 'cn.enilu.guns.admin.modular.door.EntranceGuardRuleController', '2019-09-09 15:43:12', '修改门禁权限', '业务日志', '名称=null;;;', 'update', '成功', '1'), ('158', 'cn.enilu.guns.admin.modular.door.EntranceGuardRuleController', '2019-09-09 15:44:42', '新增门禁权限', '业务日志', '名称=null', 'add', '成功', '1'), ('159', 'cn.enilu.guns.admin.modular.door.EntranceGuardRuleController', '2019-09-09 15:46:10', '新增门禁权限', '业务日志', '名称=null', 'add', '成功', '1'), ('160', 'cn.enilu.guns.admin.modular.door.EntranceGuardRuleController', '2019-09-09 15:48:09', '新增门禁权限', '业务日志', '名称=null', 'add', '成功', '1'), ('161', 'cn.enilu.guns.admin.modular.door.EntranceGuardRuleController', '2019-09-09 15:55:34', '修改门禁权限', '业务日志', '名称=null;;;', 'update', '成功', '1'), ('162', 'cn.enilu.guns.admin.modular.door.EntranceGuardRuleController', '2019-09-10 10:43:04', '修改门禁权限', '业务日志', '名称=null;;;', 'update', '成功', '1'), ('163', 'cn.enilu.guns.admin.modular.door.EntranceGuardRuleController', '2019-09-10 10:43:10', '修改门禁权限', '业务日志', '名称=null;;;', 'update', '成功', '1'), ('164', 'cn.enilu.guns.admin.modular.door.EntranceGuardRuleController', '2019-09-10 10:43:17', '修改门禁权限', '业务日志', '名称=null;;;', 'update', '成功', '1'), ('165', 'cn.enilu.guns.admin.modular.system.controller.UserMgrController', '2019-09-10 10:44:47', '修改管理员', '业务日志', '账号=admin1;;;字段名称:名字,旧值:管理员,新值:管理员1', 'edit', '成功', '1'), ('166', 'cn.enilu.guns.admin.modular.system.controller.UserMgrController', '2019-09-10 10:45:17', '修改管理员', '业务日志', '账号=admin2;;;字段名称:名字,旧值:管理员,新值:管理员2', 'edit', '成功', '1'), ('167', 'cn.enilu.guns.admin.modular.system.controller.UserMgrController', '2019-09-10 10:45:25', '修改管理员', '业务日志', '账号=admin3;;;字段名称:名字,旧值:管理员,新值:管理员3', 'edit', '成功', '1'), ('168', 'cn.enilu.guns.admin.modular.system.controller.UserMgrController', '2019-09-10 10:45:31', '修改管理员', '业务日志', '账号=developer1;;;字段名称:名字,旧值:网站管理员,新值:网站管理员1', 'edit', '成功', '1'), ('169', 'cn.enilu.guns.admin.modular.system.controller.UserMgrController', '2019-09-10 10:45:36', '修改管理员', '业务日志', '账号=admin4;;;字段名称:名字,旧值:管理员,新值:管理员5', 'edit', '成功', '1'), ('170', 'cn.enilu.guns.admin.modular.system.controller.UserMgrController', '2019-09-10 10:45:46', '修改管理员', '业务日志', '账号=developer3;;;字段名称:名字,旧值:网站管理员,新值:网站管理员2', 'edit', '成功', '1'), ('171', 'cn.enilu.guns.admin.modular.door.EntranceGuardRuleController', '2019-09-10 10:50:38', '门禁权限添加人员', '业务日志', '名称=null', 'assignRole', '成功', '1'), ('172', 'cn.enilu.guns.admin.modular.door.EntranceGuardRuleController', '2019-09-10 11:54:28', '门禁权限添加人员', '业务日志', '名称=null', 'assignRole', '成功', '1'), ('173', 'cn.enilu.guns.admin.modular.door.EntranceGuardRuleController', '2019-09-10 12:03:07', '门禁权限添加人员', '业务日志', '名称=null', 'assignRole', '成功', '1'), ('174', 'cn.enilu.guns.admin.modular.door.EntranceGuardRuleController', '2019-09-11 10:52:36', '获取门禁权限已分配的人员', '业务日志', '名称=null', 'selectUserForRule', '成功', '1'), ('175', 'cn.enilu.guns.admin.modular.door.EntranceGuardRuleController', '2019-09-11 10:52:43', '门禁权限添加人员', '业务日志', '名称=null', 'assignRule', '成功', '1'), ('176', 'cn.enilu.guns.admin.modular.door.EntranceGuardRuleController', '2019-09-11 10:52:45', '获取门禁权限已分配的人员', '业务日志', '名称=null', 'selectUserForRule', '成功', '1'), ('177', 'cn.enilu.guns.admin.modular.door.EntranceGuardRuleController', '2019-09-11 11:07:52', '获取门禁权限已分配的人员', '业务日志', '名称=null', 'selectUserForRule', '成功', '1'), ('178', 'cn.enilu.guns.admin.modular.door.EntranceGuardRuleController', '2019-09-11 11:10:32', '获取门禁权限已分配的人员', '业务日志', '名称=null', 'selectUserForRule', '成功', '1'), ('179', 'cn.enilu.guns.admin.modular.door.EntranceGuardRuleController', '2019-09-11 12:50:40', '获取门禁权限已分配的人员', '业务日志', '名称=null', 'selectUserForRule', '成功', '1'), ('180', 'cn.enilu.guns.admin.modular.door.EntranceGuardRuleController', '2019-09-11 12:51:08', '门禁权限添加人员', '业务日志', '名称=null', 'assignRule', '成功', '1'), ('181', 'cn.enilu.guns.admin.modular.door.EntranceGuardRuleController', '2019-09-11 12:51:15', '获取门禁权限已分配的人员', '业务日志', '名称=null', 'selectUserForRule', '成功', '1'), ('182', 'cn.enilu.guns.admin.modular.door.EntranceGuardRuleController', '2019-09-11 12:51:21', '门禁权限添加人员', '业务日志', '名称=null', 'assignRule', '成功', '1'), ('183', 'cn.enilu.guns.admin.modular.door.EntranceGuardRuleController', '2019-09-11 12:51:22', '获取门禁权限已分配的人员', '业务日志', '名称=null', 'selectUserForRule', '成功', '1'), ('184', 'cn.enilu.guns.admin.modular.door.EntranceGuardRuleController', '2019-09-11 12:59:27', '获取所有门禁权限', '业务日志', '名称=null', 'getRuleList', '成功', '1'), ('185', 'cn.enilu.guns.admin.modular.door.EntranceGuardRuleController', '2019-09-11 13:00:39', '获取所有门禁权限', '业务日志', '名称=null', 'getRuleList', '成功', '1'), ('186', 'cn.enilu.guns.admin.modular.door.EntranceGuardRuleController', '2019-09-11 13:04:45', '获取所有门禁权限', '业务日志', '名称=null', 'getRuleList', '成功', '1'), ('187', 'cn.enilu.guns.admin.modular.door.EntranceGuardRuleController', '2019-09-11 13:08:53', '获取所有门禁权限', '业务日志', '名称=null', 'getRuleList', '成功', '1'), ('188', 'cn.enilu.guns.admin.modular.door.EntranceGuardRuleController', '2019-09-11 13:10:58', '获取所有门禁权限', '业务日志', '名称=null', 'getRuleList', '成功', '1'), ('189', 'cn.enilu.guns.admin.modular.door.DoorInfoController', '2019-09-11 13:15:08', '设置门禁权限', '业务日志', '名称=null', 'assignRule', '成功', '1'), ('190', 'cn.enilu.guns.admin.modular.door.EntranceGuardRuleController', '2019-09-11 14:04:59', '获取所有门禁权限', '业务日志', '名称=null', 'getRuleList', '成功', '1'), ('191', 'cn.enilu.guns.admin.modular.door.DoorInfoController', '2019-09-11 14:05:02', '设置门禁权限', '业务日志', '名称=null', 'assignRule', '成功', '1'), ('192', 'cn.enilu.guns.admin.modular.door.EntranceGuardRuleController', '2019-09-11 14:05:05', '获取所有门禁权限', '业务日志', '名称=null', 'getRuleList', '成功', '1'), ('193', 'cn.enilu.guns.admin.modular.door.DoorInfoController', '2019-09-11 14:06:15', '设置门禁权限', '业务日志', '名称=null', 'assignRule', '成功', '1'), ('194', 'cn.enilu.guns.admin.modular.door.EntranceGuardRuleController', '2019-09-11 14:07:27', '获取所有门禁权限', '业务日志', '名称=null', 'getRuleList', '成功', '1'), ('195', 'cn.enilu.guns.admin.modular.door.DoorInfoController', '2019-09-11 14:07:30', '设置门禁权限', '业务日志', '名称=null', 'assignRule', '成功', '1'), ('196', 'cn.enilu.guns.admin.modular.door.EntranceGuardRuleController', '2019-09-11 14:07:33', '获取所有门禁权限', '业务日志', '名称=null', 'getRuleList', '成功', '1'), ('197', 'cn.enilu.guns.admin.modular.door.EntranceGuardRuleController', '2019-09-11 14:26:14', '获取所有门禁权限', '业务日志', '名称=null', 'getRuleList', '成功', '1'), ('198', 'cn.enilu.guns.admin.modular.door.EntranceGuardRuleController', '2019-09-11 14:55:27', '获取门禁权限已分配的人员', '业务日志', '名称=null', 'selectUserForRule', '成功', '1'), ('199', 'cn.enilu.guns.admin.modular.door.EntranceGuardRuleController', '2019-09-11 14:55:51', '获取所有门禁权限', '业务日志', '名称=null', 'getRuleList', '成功', '1'), ('200', 'cn.enilu.guns.admin.modular.door.DoorInfoController', '2019-09-11 14:55:54', '设置门禁权限', '业务日志', '名称=null', 'assignRule', '成功', '1'), ('201', 'cn.enilu.guns.admin.modular.door.EntranceGuardRuleController', '2019-09-11 14:55:57', '获取所有门禁权限', '业务日志', '名称=null', 'getRuleList', '成功', '1'), ('202', 'cn.enilu.guns.admin.modular.system.controller.MenuController', '2019-09-14 03:25:11', '菜单新增', '业务日志', '菜单名称=搜索设备', 'add', '成功', '1'), ('203', 'cn.enilu.guns.admin.modular.system.controller.MenuController', '2019-09-14 03:31:25', '修改菜单', '业务日志', '菜单名称=设备管理;;;字段名称:菜单排序号,旧值:6,新值:1', 'edit', '成功', '1'), ('204', 'cn.enilu.guns.admin.modular.system.controller.MenuController', '2019-09-14 04:08:59', '修改菜单', '业务日志', '菜单名称=搜索设备;;;字段名称:url地址,旧值:123,新值:/door/device/mgr', 'edit', '成功', '1'), ('205', 'cn.enilu.guns.admin.modular.system.controller.MenuController', '2019-09-16 06:55:51', '菜单新增', '业务日志', '菜单名称=批量发卡', 'add', '成功', '1'), ('206', 'cn.enilu.guns.admin.modular.system.controller.MenuController', '2019-09-16 06:56:48', '菜单新增', '业务日志', '菜单名称=添加', 'add', '成功', '1'), ('207', 'cn.enilu.guns.admin.modular.system.controller.MenuController', '2019-09-16 06:57:35', '菜单新增', '业务日志', '菜单名称=修改', 'add', '成功', '1'), ('208', 'cn.enilu.guns.admin.modular.system.controller.MenuController', '2019-09-16 06:58:21', '菜单新增', '业务日志', '菜单名称=删除', 'add', '成功', '1'), ('209', 'cn.enilu.guns.admin.modular.door.EntranceGuardRuleController', '2019-09-16 07:03:01', '获取门禁权限已分配的人员', '业务日志', '名称=null', 'selectUserForRule', '成功', '1'), ('210', 'cn.enilu.guns.admin.modular.door.UserCardController', '2019-09-16 07:07:06', '新增人卡关系', '业务日志', '名称=null', 'add', '成功', '1'), ('211', 'cn.enilu.guns.admin.modular.door.UserCardController', '2019-09-16 07:13:43', '新增人卡关系', '业务日志', '名称=null', 'add', '成功', '1'), ('212', 'cn.enilu.guns.admin.modular.system.controller.UserMgrController', '2019-09-16 07:21:30', '添加管理员', '业务日志', '账号=2', 'add', '成功', '1'), ('213', 'cn.enilu.guns.admin.modular.door.UserCardController', '2019-09-16 07:24:02', '新增人卡关系', '业务日志', '名称=null', 'add', '成功', '1'), ('214', 'cn.enilu.guns.admin.modular.door.UserCardController', '2019-09-16 07:30:05', '新增人卡关系', '业务日志', '名称=null', 'add', '成功', '1'), ('215', 'cn.enilu.guns.admin.modular.door.EntranceGuardRuleController', '2019-09-16 07:41:57', '获取所有门禁权限', '业务日志', '名称=null', 'getRuleList', '成功', '1'), ('216', 'cn.enilu.guns.admin.modular.door.EntranceGuardRuleController', '2019-09-16 07:42:15', '获取门禁权限已分配的人员', '业务日志', '名称=null', 'selectUserForRule', '成功', '1'), ('217', 'cn.enilu.guns.admin.modular.door.UserCardController', '2019-09-16 07:50:49', '新增人卡关系', '业务日志', '名称=null', 'add', '成功', '1');
COMMIT;

-- ----------------------------
--  Table structure for `t_sys_relation`
-- ----------------------------
DROP TABLE IF EXISTS `t_sys_relation`;
CREATE TABLE `t_sys_relation` (
  `ID` bigint(19) NOT NULL AUTO_INCREMENT,
  `MENUID` bigint(19) DEFAULT NULL,
  `ROLEID` bigint(19) DEFAULT NULL,
  PRIMARY KEY (`ID`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=529 DEFAULT CHARSET=utf8 COLLATE=utf8_bin ROW_FORMAT=DYNAMIC COMMENT='角色菜单关系';

-- ----------------------------
--  Records of `t_sys_relation`
-- ----------------------------
BEGIN;
INSERT INTO `t_sys_relation` VALUES ('7', '56', '2'), ('445', '1', '1'), ('446', '4', '1'), ('447', '5', '1'), ('448', '6', '1'), ('449', '7', '1'), ('450', '8', '1'), ('451', '9', '1'), ('452', '10', '1'), ('453', '11', '1'), ('454', '40', '1'), ('455', '41', '1'), ('456', '42', '1'), ('457', '12', '1'), ('458', '13', '1'), ('459', '14', '1'), ('460', '15', '1'), ('461', '16', '1'), ('462', '37', '1'), ('463', '38', '1'), ('464', '39', '1'), ('465', '17', '1'), ('466', '18', '1'), ('467', '19', '1'), ('468', '20', '1'), ('469', '28', '1'), ('470', '29', '1'), ('471', '21', '1'), ('472', '23', '1'), ('473', '24', '1'), ('474', '30', '1'), ('475', '31', '1'), ('476', '32', '1'), ('477', '36', '1'), ('478', '22', '1'), ('479', '25', '1'), ('480', '26', '1'), ('481', '27', '1'), ('482', '33', '1'), ('483', '34', '1'), ('484', '35', '1'), ('485', '43', '1'), ('486', '44', '1'), ('487', '45', '1'), ('488', '46', '1'), ('489', '47', '1'), ('490', '48', '1'), ('491', '49', '1'), ('492', '50', '1'), ('493', '3', '1'), ('494', '58', '1'), ('495', '60', '1'), ('496', '61', '1'), ('497', '59', '1'), ('498', '62', '1'), ('499', '63', '1'), ('500', '64', '1'), ('501', '65', '1'), ('502', '56', '1'), ('503', '66', '1'), ('504', '67', '1'), ('505', '68', '1'), ('506', '69', '1'), ('507', '70', '1'), ('508', '71', '1'), ('509', '72', '1'), ('510', '73', '1'), ('511', '74', '1'), ('512', '83', '1'), ('513', '75', '1'), ('514', '76', '1'), ('515', '77', '1'), ('516', '187', '1'), ('517', '188', '1'), ('518', '189', '1'), ('519', '190', '1'), ('520', '78', '1'), ('521', '79', '1'), ('522', '80', '1'), ('523', '81', '1'), ('524', '82', '1'), ('525', '183', '1'), ('526', '184', '1'), ('527', '185', '1'), ('528', '186', '1');
COMMIT;

-- ----------------------------
--  Table structure for `t_sys_role`
-- ----------------------------
DROP TABLE IF EXISTS `t_sys_role`;
CREATE TABLE `t_sys_role` (
  `ID` bigint(19) NOT NULL AUTO_INCREMENT,
  `CREATE_BY` bigint(19) DEFAULT NULL COMMENT '创建人',
  `CREATE_TIME` datetime DEFAULT NULL COMMENT '创建时间/注册时间',
  `MODIFY_BY` bigint(19) DEFAULT NULL COMMENT '最后更新人',
  `MODIFY_TIME` datetime DEFAULT NULL COMMENT '最后更新时间',
  `DEPTID` bigint(19) DEFAULT NULL,
  `NAME` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `NUM` int(10) DEFAULT NULL,
  `PID` bigint(19) DEFAULT NULL,
  `TIPS` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `VERSION` int(10) DEFAULT NULL,
  PRIMARY KEY (`ID`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COLLATE=utf8_bin ROW_FORMAT=DYNAMIC COMMENT='角色';

-- ----------------------------
--  Records of `t_sys_role`
-- ----------------------------
BEGIN;
INSERT INTO `t_sys_role` VALUES ('1', null, null, null, null, '24', '超级管理员', '1', '0', 'administrator', '1'), ('2', null, null, null, null, '25', '网站管理员', '1', '1', 'developer', null);
COMMIT;

-- ----------------------------
--  Table structure for `t_sys_task`
-- ----------------------------
DROP TABLE IF EXISTS `t_sys_task`;
CREATE TABLE `t_sys_task` (
  `ID` bigint(19) NOT NULL AUTO_INCREMENT,
  `CREATE_BY` bigint(19) DEFAULT NULL COMMENT '创建人',
  `CREATE_TIME` datetime DEFAULT NULL COMMENT '创建时间/注册时间',
  `MODIFY_BY` bigint(19) DEFAULT NULL COMMENT '最后更新人',
  `MODIFY_TIME` datetime DEFAULT NULL COMMENT '最后更新时间',
  `CONCURRENT` tinyint(3) DEFAULT NULL COMMENT '是否允许并发',
  `CRON` varchar(50) COLLATE utf8_bin DEFAULT NULL COMMENT '定时规则',
  `DATA` text COLLATE utf8_bin COMMENT '执行参数',
  `DISABLED` tinyint(3) DEFAULT NULL COMMENT '是否禁用',
  `EXEC_AT` datetime DEFAULT NULL COMMENT '执行时间',
  `EXEC_RESULT` text COLLATE utf8_bin COMMENT '执行结果',
  `JOB_CLASS` varchar(255) COLLATE utf8_bin DEFAULT NULL COMMENT '执行类',
  `JOB_GROUP` varchar(50) COLLATE utf8_bin DEFAULT NULL COMMENT '任务组名',
  `NAME` varchar(50) COLLATE utf8_bin DEFAULT NULL COMMENT '任务名',
  `NOTE` varchar(255) COLLATE utf8_bin DEFAULT NULL COMMENT '任务说明',
  PRIMARY KEY (`ID`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_bin ROW_FORMAT=DYNAMIC COMMENT='定时任务';

-- ----------------------------
--  Records of `t_sys_task`
-- ----------------------------
BEGIN;
INSERT INTO `t_sys_task` VALUES ('1', '1', '2018-12-28 09:54:00', '-1', '2019-03-27 11:47:11', '0', '0 0/30 * * * ?', 0x7b0a226170706e616d65223a202267756e732d6c697465222c0a2276657273696f6e223a310a7d0a2020202020202020202020200a2020202020202020202020200a2020202020202020202020200a2020202020202020202020200a2020202020202020202020200a2020202020202020202020200a2020202020202020202020200a2020202020202020202020200a2020202020202020202020200a2020202020202020202020200a2020202020202020202020200a202020202020202020202020, '0', '2019-03-27 11:47:00', 0xe689a7e8a18ce68890e58a9f, 'cn.enilu.guns.service.task.job.HelloJob', 'default', '测试任务', '测试任务,每30分钟行一次');
COMMIT;

-- ----------------------------
--  Table structure for `t_sys_task_log`
-- ----------------------------
DROP TABLE IF EXISTS `t_sys_task_log`;
CREATE TABLE `t_sys_task_log` (
  `ID` bigint(19) NOT NULL AUTO_INCREMENT,
  `EXEC_AT` datetime DEFAULT NULL COMMENT '执行时间',
  `EXEC_SUCCESS` int(10) DEFAULT NULL COMMENT '执行结果（成功:1、失败:0)',
  `ID_TASK` bigint(19) DEFAULT NULL,
  `JOB_EXCEPTION` varchar(500) COLLATE utf8_bin DEFAULT NULL COMMENT '抛出异常',
  `NAME` varchar(50) COLLATE utf8_bin DEFAULT NULL COMMENT '任务名',
  PRIMARY KEY (`ID`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin ROW_FORMAT=DYNAMIC COMMENT='定时任务日志';

-- ----------------------------
--  Table structure for `t_sys_user`
-- ----------------------------
DROP TABLE IF EXISTS `t_sys_user`;
CREATE TABLE `t_sys_user` (
  `ID` bigint(19) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `CREATE_BY` bigint(19) DEFAULT NULL COMMENT '创建人',
  `CREATE_TIME` datetime DEFAULT NULL COMMENT '创建时间/注册时间',
  `MODIFY_BY` bigint(19) DEFAULT NULL COMMENT '最后更新人',
  `MODIFY_TIME` datetime DEFAULT NULL COMMENT '最后更新时间',
  `ACCOUNT` varchar(255) COLLATE utf8_bin DEFAULT NULL COMMENT '帐号',
  `AVATAR` varchar(255) COLLATE utf8_bin DEFAULT NULL COMMENT '头像',
  `BIRTHDAY` datetime DEFAULT NULL COMMENT '出生日期',
  `DEPTID` bigint(19) DEFAULT NULL COMMENT '部门编号',
  `EMAIL` varchar(255) COLLATE utf8_bin DEFAULT NULL COMMENT '邮箱',
  `NAME` varchar(255) COLLATE utf8_bin DEFAULT NULL COMMENT '姓名',
  `PASSWORD` varchar(255) COLLATE utf8_bin DEFAULT NULL COMMENT '密码',
  `PHONE` varchar(255) COLLATE utf8_bin DEFAULT NULL COMMENT '手机',
  `ROLEID` varchar(255) COLLATE utf8_bin DEFAULT NULL COMMENT '角色id',
  `SALT` varchar(255) COLLATE utf8_bin DEFAULT NULL COMMENT '盐值',
  `SEX` int(10) DEFAULT NULL COMMENT '性别',
  `STATUS` int(10) DEFAULT NULL COMMENT '状态',
  `VERSION` int(10) DEFAULT NULL COMMENT '版本',
  `credentials_type` varchar(32) COLLATE utf8_bin DEFAULT NULL COMMENT '证件类型',
  `credentials_no` varchar(32) COLLATE utf8_bin DEFAULT NULL COMMENT '证件号码',
  `position` varchar(32) COLLATE utf8_bin DEFAULT NULL COMMENT '职位',
  `Entry_Date` datetime DEFAULT NULL COMMENT '入职日期',
  `serial_number` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  PRIMARY KEY (`ID`) USING BTREE,
  KEY `FK13fl5t0e63pakyui9apdv41d7` (`DEPTID`) USING BTREE,
  CONSTRAINT `FK13fl5t0e63pakyui9apdv41d7` FOREIGN KEY (`DEPTID`) REFERENCES `t_sys_dept` (`ID`)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8 COLLATE=utf8_bin ROW_FORMAT=DYNAMIC COMMENT='系统管理员';

-- ----------------------------
--  Records of `t_sys_user`
-- ----------------------------
BEGIN;
INSERT INTO `t_sys_user` VALUES ('-1', null, null, null, null, 'system', null, null, null, null, '应用系统', 'avatar.png', null, null, null, null, null, null, null, null, null, null, null), ('1', null, '2016-01-29 08:49:53', '1', '2019-03-20 23:45:24', 'admin', 'avatar.png', '2017-05-05 00:00:00', '3', 'eniluzt@qq.com', '管理员', '6ab1f386d715cfb6be85de941d438b02', null, '1', '8pgby', '2', '1', '25', null, null, null, null, null), ('2', null, '2018-09-13 17:21:02', '1', '2019-01-09 23:05:51', 'developer', 'avatar.png', '2017-12-31 00:00:00', '4', 'eniluzt@qq.com', '网站管理员', '4552805b07a4bf92ce1cea0373aab868', '', '2', 'vscp9', '1', '1', null, null, null, null, null, null), ('3', null, '2016-01-29 08:49:53', '1', '2019-09-10 10:44:47', 'admin1', 'avatar.png', '2017-05-04 16:00:00', '3', null, '管理员1', '6ab1f386d715cfb6be85de941d438b02', null, '1', '8pgby', '2', '1', '25', '', '', '', '2017-05-04 16:00:00', ''), ('4', null, '2016-01-29 08:49:53', '1', '2019-09-10 10:45:17', 'admin2', 'avatar.png', '2017-05-04 16:00:00', '3', null, '管理员2', '6ab1f386d715cfb6be85de941d438b02', null, '1', '8pgby', '2', '1', '25', '', '', '', '2017-05-04 16:00:00', ''), ('5', null, '2016-01-29 08:49:53', '1', '2019-09-10 10:45:25', 'admin3', 'avatar.png', '2017-05-04 16:00:00', '3', null, '管理员3', '6ab1f386d715cfb6be85de941d438b02', null, '1', '8pgby', '2', '1', '25', '', '', '', '2017-05-04 16:00:00', ''), ('6', null, '2018-09-13 17:21:02', '1', '2019-09-10 10:45:31', 'developer1', 'avatar.png', '2017-12-30 16:00:00', '4', null, '网站管理员1', '4552805b07a4bf92ce1cea0373aab868', null, '2', 'vscp9', '1', '1', null, '', '', '', '2017-12-30 16:00:00', ''), ('7', null, '2016-01-29 08:49:53', '1', '2019-09-10 10:45:36', 'admin4', 'avatar.png', '2017-05-04 16:00:00', '3', null, '管理员5', '6ab1f386d715cfb6be85de941d438b02', null, '1', '8pgby', '2', '1', '25', '', '', '', '2017-05-04 16:00:00', ''), ('8', null, '2018-09-13 17:21:02', '1', '2019-09-10 10:45:45', 'developer3', 'avatar.png', '2017-12-30 16:00:00', '4', null, '网站管理员2', '4552805b07a4bf92ce1cea0373aab868', null, '2', 'vscp9', '1', '1', null, '', '', '', '2017-12-30 16:00:00', ''), ('9', '1', '2019-09-16 07:21:30', '1', '2019-09-16 07:21:30', '2', null, '2019-09-18 11:00:00', '2', null, '2', '0c682e12837101d20dd266089975fc7c', null, null, 'wozvf', '2', '1', null, '2', '2', '2', '2019-09-15 11:00:00', '2');
COMMIT;

-- ----------------------------
--  Table structure for `t_test_boy`
-- ----------------------------
DROP TABLE IF EXISTS `t_test_boy`;
CREATE TABLE `t_test_boy` (
  `ID` bigint(19) NOT NULL AUTO_INCREMENT,
  `CREATE_BY` bigint(19) DEFAULT NULL COMMENT '创建人',
  `CREATE_TIME` datetime DEFAULT NULL COMMENT '创建时间/注册时间',
  `MODIFY_BY` bigint(19) DEFAULT NULL COMMENT '最后更新人',
  `MODIFY_TIME` datetime DEFAULT NULL COMMENT '最后更新时间',
  `AGE` int(10) DEFAULT NULL COMMENT '年龄',
  `BIRTHDAY` varchar(12) COLLATE utf8_bin DEFAULT NULL COMMENT '生日',
  `HAS_GIRL_FRIEND` tinyint(3) DEFAULT NULL COMMENT '是否有女朋友',
  `NAME` varchar(32) COLLATE utf8_bin DEFAULT NULL COMMENT '姓名',
  PRIMARY KEY (`ID`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_bin ROW_FORMAT=DYNAMIC COMMENT='男孩';

-- ----------------------------
--  Records of `t_test_boy`
-- ----------------------------
BEGIN;
INSERT INTO `t_test_boy` VALUES ('1', null, null, null, null, '18', '2000-01-01', '1', '张三');
COMMIT;

-- ----------------------------
--  Table structure for `t_test_girl`
-- ----------------------------
DROP TABLE IF EXISTS `t_test_girl`;
CREATE TABLE `t_test_girl` (
  `ID` bigint(19) NOT NULL AUTO_INCREMENT,
  `CREATE_BY` bigint(19) DEFAULT NULL COMMENT '创建人',
  `CREATE_TIME` datetime DEFAULT NULL COMMENT '创建时间/注册时间',
  `MODIFY_BY` bigint(19) DEFAULT NULL COMMENT '最后更新人',
  `MODIFY_TIME` datetime DEFAULT NULL COMMENT '最后更新时间',
  `AGE` int(10) DEFAULT NULL COMMENT '年龄',
  `BIRTHDAY` date DEFAULT NULL COMMENT '生日',
  `HAS_BOY_FRIEND` tinyint(3) DEFAULT NULL COMMENT '是否由男朋友',
  `NAME` varchar(32) COLLATE utf8_bin DEFAULT NULL COMMENT '姓名',
  PRIMARY KEY (`ID`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin ROW_FORMAT=DYNAMIC COMMENT='女孩';

-- ----------------------------
--  Table structure for `t_time_info`
-- ----------------------------
DROP TABLE IF EXISTS `t_time_info`;
CREATE TABLE `t_time_info` (
  `ID` bigint(19) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `CREATE_BY` bigint(19) DEFAULT NULL COMMENT '创建人',
  `CREATE_TIME` datetime DEFAULT NULL COMMENT '创建时间/注册时间',
  `MODIFY_BY` bigint(19) DEFAULT NULL COMMENT '最后更新人',
  `MODIFY_TIME` datetime DEFAULT NULL COMMENT '最后更新时间',
  `VERSION` int(10) DEFAULT NULL,
  `name` varchar(64) COLLATE utf8_bin DEFAULT NULL COMMENT '时段名称',
  PRIMARY KEY (`ID`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COLLATE=utf8_bin ROW_FORMAT=DYNAMIC COMMENT='时间段信息';

-- ----------------------------
--  Records of `t_time_info`
-- ----------------------------
BEGIN;
INSERT INTO `t_time_info` VALUES ('1', null, null, null, null, null, '时段1'), ('2', null, null, null, null, null, '时段2'), ('3', null, null, null, null, null, '时段3');
COMMIT;

-- ----------------------------
--  Table structure for `t_user_card`
-- ----------------------------
DROP TABLE IF EXISTS `t_user_card`;
CREATE TABLE `t_user_card` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `create_by` bigint(20) DEFAULT NULL COMMENT '创建人',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间/注册时间',
  `modify_by` bigint(20) DEFAULT NULL COMMENT '最后更新人',
  `modify_time` datetime DEFAULT NULL COMMENT '最后更新时间',
  `card_id` bigint(19) DEFAULT NULL COMMENT '卡id',
  `user_id` bigint(19) DEFAULT NULL COMMENT '用户id',
  `version` int(10) DEFAULT NULL,
  `card_no` varchar(255) DEFAULT NULL COMMENT '卡号',
  `is_unbinding` int(10) DEFAULT NULL COMMENT '是否解綁  0 否 1 是',
  `status` int(10) DEFAULT NULL COMMENT '卡狀態',
  PRIMARY KEY (`id`) USING BTREE,
  KEY `FKpx4qexc1l37n5vgp70ij6h4jg` (`user_id`) USING BTREE
) ENGINE=MyISAM AUTO_INCREMENT=8 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='人卡关系';

-- ----------------------------
--  Records of `t_user_card`
-- ----------------------------
BEGIN;
INSERT INTO `t_user_card` VALUES ('1', null, '2019-09-16 20:08:05', null, null, '1223', '1', null, '12', null, null), ('2', null, null, null, null, null, null, null, '22', null, null), ('3', null, null, null, null, null, null, null, '3', null, null), ('4', null, null, null, null, null, null, null, '4', null, null), ('5', null, null, null, null, null, null, null, '45', null, null), ('6', null, null, null, null, null, '3', null, '3', null, null), ('7', null, null, null, null, null, '4', null, '4', null, null);
COMMIT;

-- ----------------------------
--  Table structure for `t_usre_catd`
-- ----------------------------
DROP TABLE IF EXISTS `t_usre_catd`;
CREATE TABLE `t_usre_catd` (
  `ID` bigint(19) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `CREATE_BY` bigint(19) DEFAULT NULL COMMENT '创建人',
  `CREATE_TIME` datetime DEFAULT NULL COMMENT '创建时间/注册时间',
  `MODIFY_BY` bigint(19) DEFAULT NULL COMMENT '最后更新人',
  `MODIFY_TIME` datetime DEFAULT NULL COMMENT '最后更新时间',
  `VERSION` int(10) DEFAULT NULL,
  `USER_ID` bigint(19) DEFAULT NULL COMMENT '用户id',
  `CARD_ID` bigint(19) DEFAULT NULL COMMENT '卡id',
  PRIMARY KEY (`ID`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin ROW_FORMAT=DYNAMIC COMMENT='人卡关系';

SET FOREIGN_KEY_CHECKS = 1;
